johnmow's avatar
johnmow
New Member
11 years ago
Status:
Completed

Allow calculated measures that use Date/Time data format

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.
power bi

3 Comments

  • saurabh_sharma's avatar
    saurabh_sharma
    New Member
    6 years ago
    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
  • katrina1's avatar
    katrina1
    New Member
    6 years ago
    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.

Recent ideas