09-05-2019 15:59 PM - last edited 09-06-2019 18:24 PM
I was thinking about how to participate in Back to school contest last week and I said what do I like? and how it can be useful for everyone else, so first of all, I like to play with Data, any kind of data, using M Language, DAX, Azure Data Factory, etc. so I don't need to confess that I'm #DataLover #PowerBILover #AzureLover. So I just pick a topic inside Power BI and as you know one of the most important languages inside Power BI are M (Power Query) and DAX, so why don't try to provide useful public information about DAX language using M language? And here I am. After playing some hours with Power Query and Power BI, I've created this kind of guide about DAX language in Power BI so you can start playing with your data using DAX after and see the power of DAX.
This report contains information about DAX which is automatically refreshed in a daily basis reading directly online information from Microsoft Docs and Pragmatic Works websites.
Now, in order to create this report I have played with Html code and using Power BI features, there are many differente ways to get the same result but these are some of the features applied to my Power BI file:
I've attached the PBIX file so in case you are new Power BI user you can review some of the features you can use to play with data and try to do it by yourself. And in case you are an advanced user also you can check and send me some suggestions in order to improve my code or if something is wrong I could fix it.
I hope this helps and be useful in your DAX researching. Any suggestions/corrections are very welcome.
Thanks and have a good day!
Gian Carlo Poggi