topic Re: how to 'last refresh date'? in DAX Commands and Tips

how to 'last refresh date'?

Anonymous — Fri, 25 Feb 2022 07:59:40 GMT

I am trying to display in a front page of my .pbix the "last refresh date".

I have an SSAS cube where I consume from: I have the option of creating a new measure with code NOW()

But I also have the option to create a calculated column in my DimDate and add code NOW() in the calculated column.

Is there any option that is better/more robust? Shall I go with calculated column or a new measure?

Re: how to 'last refresh date'?

ValtteriN — Fri, 25 Feb 2022 08:47:01 GMT

Hi,

I recommend adding a new table in PQ like this:

let

Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}}),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Date Last Refreshed", type datetimezone}})

#"Changed Type"

The use that in a KPI.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

Re: how to 'last refresh date'?

Anonymous — Fri, 25 Feb 2022 09:17:27 GMT

I am consuming from SSAS cube, I cannot touch the model... I can only, either create a measure or a calculated column in the SSAS tabular model.

Re: how to 'last refresh date'?

ValtteriN — Fri, 25 Feb 2022 11:10:51 GMT

Anonymous

I see. In that case I would use NOW() in a measure. It is my go to solution when I can't modify the data model.

Re: how to 'last refresh date'?

Anonymous — Tue, 01 Mar 2022 08:42:08 GMT

Hi Anonymous

Create a measure to display the last refresh date .

Measure = NOW()

Best Regards

Community Support Team _ Ailsa Tao

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