John Mower on 26 Nov 2014 06:15:47
I have a common requirement to show the "freshness" of my data in a report. Usually I create a calculated measure like MAX(CreatedDate) and expose it in a "ReadMe" page of my report. Current Power View does not even show these measures in the field list, Dashboard preview reports expose the measures but they fail when I try to use them in a table or on a card.
- Comments (2)
RE: Allow calculated measures that use Date/Time data format
Hi, I am able to get the date measure to show in a card. However, I cannot change the date format.
e.g. MaxTransactionDate = Max([txnDate]) returns 11/30/2015 12:00:00 AM
Although the Data load states the Type to be "Date" and the country setting is on Australian English. It should come out as 30/11/2015.
Thank you.
RE: Allow calculated measures that use Date/Time data format
Date measure is getting summed in Power BI.com datasets and not able to show data by date. Can you please help me with this