How and where to write DAX Measures for Power BI and Excel - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 6
Jose
Mynda my question is about relationships within your practice Excel file.
At about minute 4:30 you get to show the first visuals using the Forecast Costs measure created. Then you filter per IT Area and the values adjust by themselves, nice.
However I could not get the same on my side, until I added a one-to-many relationship between the IT Dept. fields in both the Forecast and the Departments sheets.
I've repeated the process, and tried to carefully copy all your steps, but clearly I'm missing something. Thanks a lot for your help.
reply
Mynda my question is about relationships within your practice Excel file.
At about minute 4:30 you get to show the first visuals using the Forecast Costs measure created. Then you filter per IT Area and the values adjust by themselves, nice.
However I could not get the same on my side, until I added a one-to-many relationship between the IT Dept. fields in both the Forecast and the Departments sheets.
I've repeated the process, and tried to carefully copy all your steps, but clearly I'm missing something. Thanks a lot for your help.
reply
Geert
This little tutorial is deceivingly simple: good for you! :-)
Experience tells me that DAX is quite a bit more cryptic and implicit than Excel or PQ, and the logic is quite a bit different from Excel.
The user really needs to study DAX in order to get their head around it.
For the uninitiated DAX measures (even simple ones) may seem like total nonsense (e.g. the condition [column1]
reply
This little tutorial is deceivingly simple: good for you! :-)
Experience tells me that DAX is quite a bit more cryptic and implicit than Excel or PQ, and the logic is quite a bit different from Excel.
The user really needs to study DAX in order to get their head around it.
For the uninitiated DAX measures (even simple ones) may seem like total nonsense (e.g. the condition [column1]
reply
Vijay
Thank you Mynda for a crisp and short DAX tutorial! Although I know many topics, including this, it's always a pleasure to watch you teach and every time I end up learning a few new things for sure! Loving it, so let the videos keep coming! --
reply
Thank you Mynda for a crisp and short DAX tutorial! Although I know many topics, including this, it's always a pleasure to watch you teach and every time I end up learning a few new things for sure! Loving it, so let the videos keep coming! --
reply
Shawn
Thank you for breaking it down simply! However, I kept asking myself why you wouldn't just use the Forecast column that was in the data versus building a DAX formula? They both have the same result, right?
reply
Thank you for breaking it down simply! However, I kept asking myself why you wouldn't just use the Forecast column that was in the data versus building a DAX formula? They both have the same result, right?
reply
Rachael
Simple and succinct explanation of Filters, expression and arguments. If you've ever wondered what these terms actually mean pay close attention from the 14 min mark. Thanks for this Mynda
reply
Simple and succinct explanation of Filters, expression and arguments. If you've ever wondered what these terms actually mean pay close attention from the 14 min mark. Thanks for this Mynda
reply
Ross
Really good video Mynda. I'd be really interested in your thoughts on the top 5 (or top 10) most useful DAX functions for Excel - perhaps as a video!
reply
Really good video Mynda. I'd be really interested in your thoughts on the top 5 (or top 10) most useful DAX functions for Excel - perhaps as a video!
reply
Add a review, comment
Other channel videos
