ฝัง
- เผยแพร่เมื่อ 26 มิ.ย. 2024
- Get Demo Files here
ko-fi.com/s/b4df518e9b
In this video we're going to cover my top 5 DAX functions that I use daily, and that everyone should learn and master first to get the most out of DAX early on.
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of TH-cam.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence
Took a non credit Power BI course offered by local Uni. Wish they used your video for intro to DAX. They started right in with calculate and time intelligence and I was completely lost. Your video did a much better job of orienting me. Wish I’d watched it before slogging through all the articles and more complicated demos they used. Thank you
The right measure would be sumx(Orders,Orders[unit_price]*Orders[quantity])
Yeap. I suppose the same. Cause 25K seems to be wrong answer
25k is because it if first does sum on the columns, ten multiply
Thank you so much for walking me thru it makes so much sense to me as a beginner to Power BI
Crisp & Clear. Thanks Bro!
I love the way you explain things, adding your videos to my Must-Watch-List. Thank you! ☻
Appreciate that, thanks!
Brilliant solution! That's what I have been looking for. Thank heaps.
love your training methodology, thanks for sharing
Appreciate that, thanks for watching!
Very good explanations. Thanks for posting.
I love you!!! Wow! You are an excellent teacher!! Love your tone of voice and pace. New subs.
Thanks a lot sir, you 're a great teacher
Thanks, it's very useful.
Awesome bro👌
You're content are premium keep doing this great help
Hope you could cover more power automate and power apps in Bi. Love your content:)
Thanks for watching Alvin, I'll try to cover more Power Automate stuff in the future!
Very well explained. Thank you sir
Good Job, Thank you
That's awesome !!
good job thank you!
Thank you too!
Excellent videos! I am trying to round down a number to the hundred. In excel I use =IFERROR(ROUNDDOWN(A1,-2), A1). I am having a real challenge making this work in Power Bi transformation.
Review and take appropriate changes in video:- Total Sale Measure calculation(@3:54) i believe total Sale can not be calculated by using sum(quantity) * sum(unit_price) in Measure with respect to CARD total
needed to review this video to make sure that my code was fine :)
Thank u 4 detail 👍, and want more dax
More to come!
Love your channel
Very useful. Could add a basic example for handling dates?
Thanks
Thanks!
Thanks for the support mate, appreciate it!
8:20- nested if statement
+1 subscriber, thank you Sir!
Thanks for the sub!
Excellent
Thank you so much 😀
Can you include TOTAL ()
I have learned a lot from most of your content. Thanks, Sir.
However, I want to ask, how can I move my report/workspace from one environment to another?
Reports can be moved to different environments by just publishing the .PBI , and workspace can be just replicated and then we can change the server details as per the environment.
👍👍
ok, so you calculate your total sales by summing up the price per unit and the total orders ..... and multiplying them... that can not work you know
Hello Fernan,
need your help to convert minutes column into seconds using DAX.
Regards,
Indra
use divide(?
Hi Fernan, Just want to ask why the Total Sales is 25K. Having scanned the data, I think the total sales cannot more than $ 1,290 considering the Quantity is 129 and the most expensive Product is $ 10. Please advise.
Hiya, I think it was definitely a mistake on the calculation on my part!
I am confused. Why do you multiply the sum of the unit price to the sum of the quantity? If the unit price changes for each product, wouldn't you need to multiple each quantity by each unit price. Or at the very least use average rather than sum for the unit price but then it's still not accurate. For example, if I had 2 apples for $1 + 3 bananas for $2. My total fruit sale is (2*1)+(3*2)=$8. But if I just multiply the unit price total and sum total it would not give me the answer at all (2+3)*(1+2)=$15.
-
Why did you use true in switch dax
Total sales should be sum(qty * unit price), isn't it?
Nope, it will not work. Use SUMX function in place of sum.......the reason is: you want a row by row calculation or want to use row context while sum is a function which use filter context..
@@palakvarshney6800 You are right. The right measure would be sumx(Orders,Orders[unit_price]*Orders[quantity])
With the DIVIDE function, you swapped numerator and denominator.
Sir, The Sum examples you are giving are misleading. You can't just add up different items.
Total Sales = Sum (Quantity x unit price). First Multiplication by row by row, followed by addition. With your dataset Total Sales Should be 806
This result t is incorrect : Sum(quantity) * Sum (unit price).
Sum (column quantity) × Sum (column unit price). This result is meaningless.
Would you please revise your tutorial.
Any Indian here who working in power BI field in India?
Me
@@palakvarshney6800 sir, please help me I'm in very confused state right now. I have learnt advanced Excel. People suggesting learn power BI. It'll help you to get good job. Can I get job only on basis of power bi and excel?
@@dexxxxxxxx Hi, I suggest plan your future wisely....if you want to proceed with the data science profile then it makes sense to learn a visualisation tool such as power bi, else learn something else....when talking about job power bi & SQL together along with excel will definitely give you a platform to get an entry level job...
@@palakvarshney6800 thank you👊🏻