Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 is a table visualization, but a column header appears above the date, and I haven't found a way to remove the header.
Similarly, there is the card visualization, but it is trying to aggregate (count) my value coming from the database, so that all that gets displayed in the card is '1', instead of the date.
I was able to get a percentage value to appear in the card control, but getting a date to appear has not worked.
Solved! Go to Solution.
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.
Proud to be a Super User!
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.
Proud to be a Super User!
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' ) )
@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.
Proud to be a Super User!
You can define a measure to calculate the MAXA of your date column and then use that.
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |