DAX Reference Cheat Sheet

For those that are looking for the upgraded version of this report, please look into this attachment. 

Do note that lots of modifications are made to the previous M codes & CSS selectors to fit the current documentation's HTML structure including changing the code logic to optimize query performance. Remarks & Examples (plus Return section) for each DAX functions are NOT working properly as another tables & data source are needed to collect these contents in order to flatten those into a record for the visuals. Due to bad performance of loading these web content with Power Query, these issues are not fixed and will not be fixed as using scripting language such as Python can scrape and transform these data faster and possibly optimizing anything for this report. Therefore, I would recommend to scrape the data separately with other tools and write to a csv file etc., then source to Power BI report. Note that refreshes might take more than 1 hour depends on your internet and resources. Nonetheless, feel free to take ownership of this report and make any changes as needed to fit your appetite.

BEST,

JKChai