Hi everyone!
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.
Websites sources:
https://docs.microsoft.com
https://pragmaticworks.com/portfolio/dax-cheat-sheet/
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:
- Power Query Parameters
- M Custom Functions
- M Custom codes (through Advanced Editor)
- HTML Table sources (in order to connect with public websites)
- Power Query Transformation functions:
- Lists
- Split Column
- Merge Column
- Merge Rows (Text Combine)
- Grouping
- Data Model (Basic relationships in order to create herarchy for DAX Functions information)
- HTML Code (modifying original HTML code in order to show required data in desired format)
- Using HTMLViewer visual in order to display custom html code
- Calculated Columns
- Bookmarks
- Edit Interactions
- Selection Pane (Grouping, Hide and Unhide)
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!
Regards,
Gian Carlo Poggi
eyJrIjoiN2NmNjI5NmEtMGUxZS00ZWRiLTlhZDgtMjU4NmFmNzkxMjI4IiwidCI6ImNhMWQwOGIwLTk1NDMtNGJkOS04NzE4LTQyYmVjZGRjNzc4NiIsImMiOjR9
