How to create max date measure for displaying in report?

[ovonel]

I am trying to do this measure in SSAS Power BI, to display the “Latest data refresh” on a report:

select max(d2.DateName)

from FactActions f

join DimActionType d on d.K_ActionType = f.K_ ActionType

join DimDate d2 on d2.K_Date = f.K_Date

where d.Product = 'xyz'

I am unable to achieve it in DAX, how can I do it?

[v-mengzhu-msft · Accepted solution]

Hi @ovonel ,

If you need to show the latest data refresh date, it is better to use power query to do it. As shown in the figure below:

For detailed creation steps you can refer to this official document, which documents the complete instruction process.

Add last refresh date to a Power BI report - Azure DevOps | Microsoft Learn

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly