how to 'last refresh date'?

[Anonymous]

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?

[Anonymous · Accepted solution]

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.

[ValtteriN]

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}})

in

#"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/

[Anonymous]

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.

[ValtteriN]

@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.