Power BI Dax SUMX Function Example | SUMX vs SUM Function in Power BI | Power BI SUMX Measure | Power BI Tutorial for Beginners in Hindi | पावर बी क्या होता है
Today, we are talking about how can we use Sumx Function in PowerBI.
Difference between SUM & SUMX (sumx in power bi):-
1) Sum works on Column level and Sumx works at Row level.
2) Sumx power bi and sum both are giving Scalar value in output.
3) sumx dax provide facility to give expression but this facility not available in sum function.
power bi sumx measure : You can use these formula only in calculated measure only otherwise there is no use of these formula in calculated column.
Power BI Sumx is not much difficult you think. sumx function in power bi is very easy to use.
You will get sumx power bi example in this video. In another video will also teach you about sumx power pivot.
Power BI Dax Functions divided into different categories like :-
Logical Functions
Statistical Functions
Text Functions
Date Functions
Comparison Functions
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.
माइक्रोसॉफ्ट पावर बीआइ एक ऐसा Platform है जो Business Analysis करने के लिए कई उपकरण प्रदान करता है । यह Different Sources से Data Import करने और एकत्रीकरण, प्रदर्शन योग्य रिपोर्ट में मंथन करने के लिए रूपांतरण करने में सक्षम है। User या Organizational आवश्यकताओं के आधार पर तदर्थ विश्लेषण किया जा सकता है।
Types of Power BI Building Blocks? Power BI बिल्डिंग ब्लॉक ?
1) Visualization 2) Dataset 3) Dashboard 4) Report 5) Title
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...
On youtube, only just few videos are available on How to use Power BI dax date functions in hindi.
I am inspired from big youtubers of Indian those are doing such a tremendous job in the field of youtube like Bhuvan Bam aka BB ki Vines in Entertainment, Techincal Guruji aka Gaurav Choudhary in Technology, Amit Bhadana in Entertainment, Technical Dost aka Hitesh in Technology. Try to educate peoples in professional manner to help them doing fast work in Data kind of work.
#powerbi #dax #datefunctions
2 окт 2024