Skip to content

Instantly share code, notes, and snippets.

@bjulius

bjulius/"C:\Users\brjul\Desktop\New folder\DAX Priority Functions.pbix"

Created September 23, 2023 20:32
Show Gist options
  • Save bjulius/4e58711f419ec56fcc7c2b17809e0344 to your computer and use it in GitHub Desktop.
Save bjulius/4e58711f419ec56fcc7c2b17809e0344 to your computer and use it in GitHub Desktop.
Download ZIP
Power BI Report to Select and Display Priority DAX Functions Based on Pareto Principle (Brian Julius)
Raw
gistfile1.txt
Attached are the files I used to create the Power BI report on applying the Pareto Principle to DAX functions.
This report is discussed at length in my post of Sept 23, 2023. This post can be found at https://bit.ly/ParetoDAX
To create and display your priority functions follow these steps:
1. Download the attached PBIX and XLSX files.
2. Open the Excel file, fill out the UserInfo tab, and then go to the DAX tab and select your top 75 DAX functions (20%) by changing the Priority column dropdown from 0 to 1 for your 75 selected functions.
4. Make sure you've selected exactly 75 functions and then save the Excel file in c:\temp or place it in a directory of your choice and go into Power Query and set the Source step to correspond to your filepath.
5. Open the PBIX file, click the "Refresh" button and you should be good to go...
If you have any questions or problems, feel free to contact me at https://www.linkedin.com/in/brianjuliusdc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment