Power BI DAX Tutorial (5/50) - What is Sum and SumX
Vložit
- čas přidán 30. 06. 2020
- What is SUM Function in DAX Power BI , What is SUMX Function in DAX Power BI, What is the difference Between Sum or SUMX in DAX Power BI , When to use SumX function in DAX, when to use SUM function in Power BI. Power BI DAX Tutorial with Examples
#powerbi #powerbidax #sumx #sum
Datasource Link
drive.google.com/file/d/1-rfO...
🏬 Visit our Amazon Influencer Store 🏬 : www.amazon.in/shop/analyticsw...
✉ Business Queries / Analytics Consulting ✉ : analyticswithnags@gmail.com
💬 For Learners Post queries and Interact 💬 : t.me/analyticswithnags
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Power Pivot 📚📖 • Power BI Tutorial (15/...
Power Query 📚📖 • Power BI Tutorial (15/...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Tamil Tutorials 📚📖 • How to do Power BI Ins...
Power BI Telugu Tutorials 📚📖 • How to do Power BI Ins...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
MSBI Tutorials - SQL + SSAS + SSIS 📚📖 • Learn SQL Complete | C...
Data Analyst - Complete Reference - Playlist 📚📖 • Data Analytics For Beg...
BI Developer - Complete Reference - Playlist
📚📖 • Power BI Tutorial From...
BI Architect - Complete Reference - Playlist
📚📖 • Power BI Full Course -...
ETL Developer - Complete Reference - Playlist 📚📖 • Building an Enterprise...
Database Developer - Complete Reference - Playlist 📚📖 • SQL Tutorial - Full Da... - Věda a technologie
Thank for making such powerful knowledgeable and easy understanding video. Earlier i was finding the measure and calculate very complicated but going through this playlist of dax i am improvising on my BI knowledge. Once again thank you so much.
Keep learning. Share this channel with friends and colleagues
@@AnalyticswithNags Definitely
You are quite popular in Pune Sir!.. Btw, I from TN. The concepts u teach are crisp and neat. Great Efforts and Thank You So Much!.
Thanks for letting us know. Keep learning. Share this channel with friends and colleagues
Best explanation of sumx and sum functions ,use of excel to explain this was simply best approach
Thanks keep learning
You made it really simple, Thanks for the tutorial.
Glad it helped!, Share and subscribe to our channel.
Thanks for the Video bro. Good Explanation and Keep rocking. Vera level neenga
Thanks keep learning share this channel with friends and colleagues
You are the best teacher I have got till today
Your voice is so clear, enthusiastic , energetic.
Thankyou so much for clearing concepts
Thanks keep learning
Thanks keep learning
Amazing video.... It made so easy to understand thank you very much.
Thanks keep learning
Thank you so so much for this video
Thanks bro …At last I understand with simple way of your explanation
Thanks follow the channel to learn power bi with simple explanation
1) SUMX: When u have to calculate row by row. ex: sum(sales, sales[unit price]*sales[QTY])
2) SUM: When doesn't require row level operation.
Thank you so much Sir for such nice demonstration, easily understandable with practical examples. This will make me learn alot from you and enhance speedy growth in my career.
Stay Blessed
You are most welcome
Hai sir today I started searching power bi related vedios you made explanation very simple sir thanks a lot for beautiful explanation sir
Thanks and welcome
Great explanation. Thanks from South Africa.
Most welcome, Keep Learning
SIR, sum and sumx working same in report while calculating total sales. But SUMX helps in finding sales amount when there is no calculated column
(ex. (qty*sales)).Instead of creating new column we create measure SUMX to work row level which helps in improving performance, and reduces memory usage right.
in simple words can we say sum works on column level
and SUMX works in row level.
if we asked this question in interview.
Watch again again. You will get the answer
Understood Sir,
When we want to work with one coloumn we need to go for SUM,
For multiple columns or row by row operations-SUMX
Thank you for good explanation
Glad it was helpful!
Such a great magical voice u have...
Welcome
Awesome!
Thank you! Cheers!
7:13 can you please explain to me what you did here so the "Argunent" go away?
Amazing explanation
Thanks keep learning share this channel with friends and colleagues
thank you sir
All the best
finished watching
Glad to help
thank you naganna miru mnc lo pani chestara or company lo as a trainer miru pani chestunara? chala manchi knowledge undi miku powerbi lo:)
Thank you
Super sir
Thanks keep learning share this channel with friends and colleagues
Sir, can we say that it will give result same as we create calculated column by product of unit price and qty column
Watch again.
Thanks keep learning share this channel with friends and colleagues
Can we do sumx from two different tables?
Need to use related function
Sir , I used sumx function to calculate profit but the value is different ,I used the profit column that is showing profit 1.31m but by performing sumx function my profit is 1.27m 😅am I doing something wrong
Data is different
Brother it is not possible to use sumx function while creating a new column,i am not getting proper result while using sumx in creating new column
In new column don’t use any function.. do with actual columns
@@AnalyticswithNags ok thank you brother
please send data set for practicing purpose
Check the description
Where i can get those presentation ppt.
we dont share the ppt
what if we use "=sum([quantity]*[unit*price])
Can you try and let me know
@@AnalyticswithNags Yes, it is working in MS office 2021, although I did not check in older versions.