Top 5 DAX functions you should learn FIRST // Beginners Guide to Power BI in 2021

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 - [e-mail]
🤵 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 KZbin.
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

[@jomilyethan]

The right measure would be sumx(Orders,Orders[unit_price]*Orders[quantity])

[@MrAstonmartin78]

Yeap. I suppose the same. Cause 25K seems to be wrong answer

[@sarahdeschene3152]

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

[@MsLanny9]

Thank you so much for walking me thru it makes so much sense to me as a beginner to Power BI

[@Ashish--Singh]

Crisp & Clear. Thanks Bro!

[@sixtyfiveroses2968]

I love the way you explain things, adding your videos to my Must-Watch-List. Thank you! ☻

[@SolutionsAbroad]

Appreciate that, thanks!

[@larahporter8123]

I love you!!! Wow! You are an excellent teacher!! Love your tone of voice and pace. New subs.

[@user-kb5yj8wf7y]

Brilliant solution! That's what I have been looking for. Thank heaps.

[@tubeitz]

love your training methodology, thanks for sharing

[@SolutionsAbroad]

Appreciate that, thanks for watching!

[@Pedro_Gorla]

Thanks a lot sir, you 're a great teacher

[@user-ri7sw2wt6f]

Very good explanations. Thanks for posting.

[@AlvinRyellPrada]

Hope you could cover more power automate and power apps in Bi. Love your content:)

[@SolutionsAbroad]

Thanks for watching Alvin, I'll try to cover more Power Automate stuff in the future!

[@Moon_Rise6393]

Awesome bro👌 You're content are premium keep doing this great help

[@joelvargas8397]

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.

[@pradeepkare4117]

Thanks, it's very useful.

[@srmyrm]

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

[@tsiferanaranaivoson1656]

needed to review this video to make sure that my code was fine :)

[@dheerajreddy3559]

Very well explained. Thank you sir

[@rickvucina3807]

Good Job, Thank you

[@LearnwithEtuk]

Thanks

[@manoharinandas2087]

Thank u 4 detail 👍, and want more dax

[@SolutionsAbroad]

More to come!

[@djcanttame5985]

good job thank you!

[@SolutionsAbroad]

Thank you too!

[@deejohn064]

Thanks!

[@SolutionsAbroad]

Thanks for the support mate, appreciate it!

[@fahimreza1377]

That's awesome !!

[@eagillum]

8:20- nested if statement

[@brianligat9493]

Very useful. Could add a basic example for handling dates?

[@karlaarguedas3035]

Love your channel

[@moneygraphit743]

Excellent

[@SolutionsAbroad]

Thank you so much 😀

[@kuldar.]

+1 subscriber, thank you Sir!

[@SolutionsAbroad]

Thanks for the sub!

[@willywales9446]

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?

[@snehakedambadi4114]

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.

[@utsavjain6204]

Hey, Is there any way we can get links of all the videos at one place. Please let me know.

[@rupaliadhikari6136]

Can you include TOTAL ()

[@David-kf8qo]

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

[@indradutta4136]

Hello Fernan, need your help to convert minutes column into seconds using DAX. Regards, Indra

[@gustavosolaeche674]

use divide(?

[@hendrag1174]

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.

[@SolutionsAbroad]

Hiya, I think it was definitely a mistake on the calculation on my part!

[@Explorewith_RJ]

👍👍

[@jomilyethan]

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. -

[@goodmanshawnhuang]

Total sales should be sum(qty * unit price), isn't it?

[@palakvarshney6800]

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..

[@jomilyethan]

@@palakvarshney6800 You are right. The right measure would be sumx(Orders,Orders[unit_price]*Orders[quantity])

[@GoVi.6565]

Why did you use true in switch dax

[@monahengramochele5218]

With the DIVIDE function, you swapped numerator and denominator.

[@afonsoosorio2099]

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.

[@dexxxxxxxx]

Any Indian here who working in power BI field in India?

[@palakvarshney6800]

Me

[@dexxxxxxxx]

@@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?

[@palakvarshney6800]

@@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...

[@dexxxxxxxx]

@@palakvarshney6800 thank you👊🏻