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.
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.
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
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?
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.
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.
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.
Thanks for this.
My pleasure!
Really helpful tips, Thanks Reid
Nice visual!
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
You can ignore that. Excel gets grumpy if there is a disconnected table. But it won't harm any measures that are in there.
How to get that Last refresh time?
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?
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.