Power BI Union Intersect Except All Except Function | Power BI Tutorial for Beginners in Hindi | पावर बी क्या होता है
Today, we are talking about how we can use below table functions in power bi :-
1) power bi union function : A table that contains all the rows from each of the two table expressions.
2) power bi intersect function : A table that contains all the rows in table_expression1 that are also in table_expression2
3) power bi except function : A table that contains the rows of one table minus all the rows of another table.
4) power bi all except function : Removes all context filters in the table except filters that have been applied to the specified columns.
Power BI DAX GROUP BY Function : The GROUPBY function is similar to the SUMMARIZE function. However, GROUPBY does not do an implicit CALCULATE for any extension columns that it adds. GROUPBY permits a new function, CURRENTGROUP(), to be used inside aggregation functions in the extension columns that it adds. GROUPBY attempts to reuse the data that has been grouped making it highly performant.
What is Power BI ?
Power BI is a business analytics service by Microsoft. It aims to provide interactive visualizations and business intelligence capabilities with an interface simple enough for end users to create their own reports and dashboards.
PowerBI videos links are below : -
1) What is Power Bi in Hindi | Power BI Tutorial for Beginners in Hindi: • What is Power Bi in Hi...
2) Power BI Building Blocks | Power BI Tutorial for Beginners in Hindi: • Power BI Building Bloc...
3) How to Download Power BI | Power BI Desktop को कैसे Download करे | What is Power Bi in Hindi: • How to Download Power ...
4) Import File from Excel Notepad Web to Power BI Desktop in Hindi | Power BI Desktop Tutorial in Hindi: • Import File from Excel...
5) Power BI Query Editor Tutorial in Hindi | Power BI Desktop Tutorial in Hindi: • Power BI Query Editor ...
6) Power BI Choose/Remove column in Hindi | Power BI Tutorial for Beginners in Hindi: • Power BI Choose/Remove...
7) Power BI KEEP & REMOVE Rows Hindi | Power BI Tutorial for Beginners in Hindi | Delete Row in PowerBI : • Power BI KEEP & REMOVE...
8) Power BI Split Column in Hindi | Power BI Tutorial for Beginners | How to split column in Power BI : • Power BI Split Column ...
9) How to use Group By in Power BI Hindi | Power BI Group By Option : • How to use Group By in...
10) Merge and Append Queries in Power BI in Hindi | Merge vs Append in Power Query | Power BI Tutorial : • Merge and Append Queri...
11) How to make Simple Interactive Dashboard in Power BI | Create Dashboard | Power BI Tutorial Hindi : • How to make Simple Int...
12) How to Create Relationship in Power BI | Types of Relationship in Power BI | Power BI Tutorial Hindi : • How to Create Relation...
13) Power BI Import vs Direct Query Hindi | Difference Between Import vs Direct Query in Power BI : • Power BI Import vs Dir...
14) What is PBIX vs PBIT File in Power BI in Hindi | How to Save PBIX and PBIT File in Power BI : • What is PBIX vs PBIT F...
15) Calculated Column vs Calculated Measure in Power BI | Power BI DAX Formula in Hindi : • Calculated Column vs C...
16) Power BI DAX Aggregate Function in Hindi Power BI Tutorial for Beginners : • Power BI DAX Aggregate...
17) Power BI DAX Text Function in Hindi | Power BI DAX Functions Hindi | Power BI Tutorial for Beginners : • Power BI DAX Text Func...
18) Power BI DAX Logical Functions in Hindi : • Power BI DAX Logical F...
19) Power BI DAX Date Functions in Hindi : • Power BI DAX Date Func...
20) Power BI DAX Sumx and Sum function : • Power BI DAX SUMX Func...
21) Power BI GroupBy vs Summarize Function : • Power BI Group By vs S...
22) Power BI Union Intersect Except All Except Function : • Power BI Union Interse...
On youtube, only just few videos are available on How to use Power BI union, intersect, except and allexcept function in hindi.
#powerbi #powerbiunion ##powerbiintersect
28 сен 2024