Power BI Desktop Introduction #4 - DAX Formulas & Creating Measures

[@tomculhane7353]

Thanks Alan, I went through quite a few videos looking for examples that were useful and easy to understand. Yours finally did the trick.

[@Computergaga]

You're very welcome! Thank you for your comments.

[@zahir585]

You are my hero 🙌🏻😁 I’ve been following you for yrs your content doesn’t get old! Please keep up the good work

[@Computergaga]

Thank you very much Zahir.

[@zylka172]

fantastic demonstration of how to tackle any new Power BI problem, from asking the questions to creating the measures. Thank you!

[@Computergaga]

Thank you Silke.

[@amnril]

I’m brand new to this and the video explained it beautifully. Of course, watching this video makes me want to know more, much more !

[@mario17-t34]

Very Very Extraordinary Explanation, Thansk much !!!! with absolutely perfect clarity and tempo, not mentioning by fav accent !! Thansk again + Happy Holidays !!!

[@Computergaga]

Wow, thank you!

[@amnril]

I’m brand new to this and the video explained it beautifully. Of course, watching this video makes me want to know more, much more ! *subscribed*

[@Computergaga]

Glad it was helpful! Thank you Neil 😀

[@hakeem1340]

beautiful language ,the topic is well explained ...thank you so much

[@Computergaga]

My pleasure. Thank you, Hakeem.

[@duggie88]

This video was exactly what I needed to start working on a dashboard for work 😭🙌🏾

[@Computergaga]

Excellent!

[@chanmiko3312]

Hi Alan, really grateful found your Power BI Desktop tutorial. Step by step guide and easy to catch up for the beginner like me.Thank you very much. Hope you will share more !!

[@Computergaga]

You're very welcome. Thank you Chan.

[@israelakowe9304]

Very detailed explanation. Thank you!

[@Computergaga]

You're very welcome. Thank you.

[@anthws]

Really nice intro video. Well done! You answered some of the exact noob questions I have on a current project. Cheers!

[@Computergaga]

Thank you.

[@kerangi5055]

Good video. Clearly understood how to make DAX formulas.

[@Computergaga]

Excellent! Thank you 😊

[@JiminPark-ld2xx]

Good video. I was searching for this kind of video and there are lot of videos and didn't help at all. Thank you. Keep going. Upload more formulas and real life examples if you can.

[@Computergaga]

Thank you, Jimin. Glad to hear that it helped.

[@wayneedmondson1065]

Hi Alan.. thanks for the creating measures fun. Looking forward to wrapping it up with the visuals in #5. Thumbs up!

[@hackyourlife2343]

This is so insightful! Excellent job, thank you so much :)

[@Computergaga]

Glad it was helpful! My pleasure.

[@RajendraPatel.]

Awesome voice n confidance ❤️❤️👌🏼

[@Computergaga]

Thank you 😊

[@AlvinRyellPrada]

Very well explained. Thanks for making it easy for me to understand this Step by step and showing how it should really be done. Thanks heaps mate

[@Computergaga]

My pleasure. Thank you Alvin.

[@joanneosborne2428]

Hi Alan, Amazing! - Thank you for taking the time to create this video. I am new to Power BI and DAX and your video is very nicely explained and really helped me to understand finally how to write a little bit of DAX.Thumbs up! I have subscribed and be definitely watching all your other videos. Cheers!

[@Computergaga]

That is great. Thank you very much Joanne. Your comments are appreciated.

[@entertainmentgalaxy971]

loving your new DAX series. thanks for sharing

[@Computergaga]

Thank you Haider. I am hoping to do a lot more tutorials on DAX, Power BI and Power Pivot. I will still be producing Excel tips and VBA stuff also.

[@entertainmentgalaxy971]

@@Computergaga it would be great to see series of m code functions what and how to use on your channel. Please add into your list

[@Computergaga]

Sure. Thanks Haider.

[@sasavienne]

Nicely explained. Awesome. Thanks Alan. 👍 🌟 🌟 🌟 🌟

[@Computergaga]

Thank you Salim.

[@TomPonce14]

Thanks! well explained and clear!

[@Computergaga]

You're welcome. Thank you.

[@WendersonReisss]

Hello! Your video is very nice. Can you create a video explaining how to creating a "First Pass Yield (FPY)" chart?

[@renatarusnakova3904]

Hi, the video is great, but I have a question... the Total Revenue measure is Total Revenue = [Total Premium]*sum(dproduct[price])), but it is not protected in the case I add a new column and I extend the dproduct table... So I am new in this, but what about this formula? Would it work? - Total Revenue = [Total Premium]*CALCULATE(SUM(dproduct[price]), dproduct[package]= '"Premium")… Thank you for your answer:)

[@DarshanKulkarniIndia]

I have one question. How to do sum of values of one column by the grouping of related another column. if you could make one video or provide formula here. that will be really helpful.

[@Computergaga]

Sounds like you need a SUMX function with RELATED. I think I use it in my introduction to Power Pivot video - kzbin.info/www/bejne/eZu2nmipfpitbtE

[@larabano6205]

Very useful

[@Computergaga]

You're welcome Lara.

[@ibjlondana6885]

Amazing!

[@Computergaga]

Thank you Izaias.

[@magicmanj32]

Can I ask a question, can I add rows/records of data in power bi, like you can do in excel.....or do I have to load excel data with new data into power bi files?

[@Computergaga]

You would load it in. So the adding of rows would still occur on a spreadsheet, or maybe a database or something else. In Power BI you would just click Refresh to update the report.

[@magicmanj32]

@@Computergaga Thank you

[@paulangelobanzuela2758]

not sure about the "SUM(dproduct[Price])"... what if you had another row for example Package: premium2, Price: 25,99.

[@Computergaga]

Then we would use a different formula. I that situation we would apply the correct price. The tables are related so it is not a problem. However, in this example, that wasn't the case so no problem.

[@deb73268]

Do you talk like this at your home also?good explaination btw😊

[@Computergaga]

I sure do, thank you 😀

[@SaniGarba]

Thank you

[@Computergaga]

My pleasure Sani.

[@simmisahay2518]

nice

[@Computergaga]

Thank you, Simmi.

[@pratyushkumarmohanty3744]

TOO MUCH HELP FUL

[@Computergaga]

Thanks Pratyush.