Forum Discussion
How to display Latest Dara Refresh?
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?
Anonymous , Try a measure like
calculate(maxX(allselected(FactActions ), [K_Date]), filter(DimActionType , DimActionType [Product] ="xyz"))
1 Reply
- amitchandak
Super User
Anonymous , Try a measure like
calculate(maxX(allselected(FactActions ), [K_Date]), filter(DimActionType , DimActionType [Product] ="xyz"))