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

Get Demo Files here

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!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

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

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

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 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 #DataAnalytics #BusinessIntelligence

[sarahdeschene]

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

[jomilyethan]

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

[MsLanny]

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

[sixtyfiveroses]

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

[larahporter]

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

[tubeitz]

love your training methodology, thanks for sharing

[kbyjwfy]

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

[Pedro_Gorla]

Thanks a lot sir, you 're a great teacher

[AlvinRyellPrada]

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

[joelvargas]

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.

[Moon_Rise]

Awesome bro👌

You're content are premium keep doing this great help

[riswwtf]

Very good explanations. Thanks for posting.

[manoharinandas]

Thank u 4 detail 👍, and want more dax

[brianligat]

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

[willywales]

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?

[David-kfqo]

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

[indradutta]

Hello Fernan,

need your help to convert minutes column into seconds using DAX.

Regards,
Indra

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

[hendrag]

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.

[goodmanshawnhuang]

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