Forum Discussion

v-dabatc's avatar
v-dabatc
Microsoft Employee
10 years ago
Solved

Display refresh date

I'd like to be able to display a 'last refreshed date' on my report.  This date value is coming from our database.  I'm looking for a control to use which will display only the refresh date.  There i...
  • kcantor's avatar
    kcantor
    10 years ago

    I just tossed one onto my reports using this expression as a measure: Last Refreshed = LASTDATE(SalesPerformance[Posting Date])

    I set it as date type then placed it on a card. While it does show the heading of last Refreshed, I can go into the settings and drop the title off of the card. What you already have should work. If you swith the data type to date it should no longer do a count.

     

greggyb's avatar
greggyb
Resident Rockstar
10 years ago

The measures above will show the last date in context. You'll need to explicitly ignore filter context coming from the slicers and filters on the report page.

 

This is fine if you have a separate table that's not related to any of those filter fields. If you're taking the last date from a fact table, though, you'll want to use an ALL() in there to make sure you're not seeing the last date for a particular dimension selection:

 

// DAX
// Measure
MostRecentDate =
CALCULATE(
    MAX( 'Fact'[Date] )
    ,ALL( 'Fact' )
)

// or using LASTDATE()

MostRecentDAte =
CALCULATE(
    LASTDATE( 'Fact'[Date] )
    ,ALL( 'Fact' )
)
kcantor's avatar
kcantor
Community Champion
10 years ago

greggybI agree.Excellent point on the DAX. I just created a quick date refreshed in context of the report currently on my desktop.

The original question was how to display it as a date in a card with no title. The original poster had the expression he wanted to use but it was showing up as a count of days instead of the actual date. I recommended changing the data type associated with the expression before placing it on a card.  Once it is on the card, my illustration  provides key locations for dropping the card label or, at the very least, hiding the label by changing the font color if it will not completely drop the label.