Creating a DAX Measures Table In Power BI Or Excel

A common pain point when building data models is how to organize your DAX Measures.
Learn a great way to organize your DAX measures by creating a table to place them in using a semi-hidden feature in Power BI or Excel.
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:12 - Content Intro
0:42 - Detailed Review of Technique
2:15 - Creating Measure Table in Power BI
6:01 - Creating a Measure Table in Excel
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog - www.havensconsulting.net/blog-...
Blog Files - www.havensconsulting.net/blog-...
Files & Templates - www.havensconsulting.net/files...
Consulting Services - www.havensconsulting.net/consu...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop

[@zzzzzzzzzzzzzzzz9]

Thanks for this.

[@HavensConsulting]

My pleasure!

[@havenscr]

Good question. It’s a card that uses a DAX measure that grabs the MAX transaction date from the data table. You can also create a single row table in Power Query that instead returns the exact time the report refreshes too.

[@medatefmekkaoui2606]

Really helpful tips, Thanks Reid

[@jackeroo75]

Nice visual!

[@muhammadusman2059]

How to get that Last refresh time?

[@ShrutiIyer88]

FYI for those who couldn't find it at 2:15, To access 'Home Table', select your measures > Measure Table will appear on the menu > Click Measure Table > Home Table > Name of the Dax Dummy Table that you created.

[@imadbabbili]

In Excel, once I move all measures to the measures table. I am receiving the warning that "Relationships between tables may be needed". How to weak this issue
This is great, thorough, and to the point post

[@HavensConsulting]

You can ignore that. Excel gets grumpy if there is a disconnected table. But it won't harm any measures that are in there.

[@johnradford3197]

I have a SQL data cube the does not have data that I need to create dashboard that I want. Since Power BI does not allow you to import additional table if you are in the Connect to Data Cube mode. I need to be able to manually enter data into a column in my data set. Is there a way to do this?

[@HavensConsulting]

Hi John, currently OLAP and Analysis Services (Tabular) models can't have additional tables joined to them in composite modes. However, this feature is being planned for release later this year.