March 2018
Beginner to intermediate
638 pages
16h 29m
English
The CurrentDate table, as described in the Data Source Parameters section of Chapter 2, Connecting to Sources and Transforming Data with M, contains only one column and one row, representing the date at the time the source M Query was executed. With this date value computed with each dataset refresh and loaded into the Data Model, a DAX Measure can be written to expose the date to the Power BI report visuals. In the following screenshot from the Report View, a measure named Last Refresh Msg uses a DAX variable to reference the parameter table and then passes this variable to a text string:

Read now
Unlock full access