topic Re: Conditionnal formatting of last refresh date in DAX Commands and Tips

Conditionnal formatting of last refresh date

Anonymous — Thu, 16 Feb 2023 16:05:15 GMT

Hello everyone,

I have my last refresh date that show up in a card visual. I would like to conditional format it so it show in red if it is older than 2 hours.

Do you guys know how to do that ? I searched for a bit but it seems nobody ever needed this, or it is so simple nobody ever asked.

Thanks in advance,

James

AilleryO — Thu, 16 Feb 2023 16:24:42 GMT

Hi,

My first idea, would be to create a Mesure to calculate the difference between now and that date-time refresh, and to check if it more than 2 hours.

Example :

MesureTest =

VAR DateToday=

TODAY ()

RETURN

IF ( LASTDATE ( TableDate[Date] ) < DateToday, 1, 0 )

Then you cas use this Mesure for conditionnal formatting.

Using Rules and if your test mesure = 0 (or 1) then choose color.

Let us know if it works

Anonymous — Fri, 17 Feb 2023 07:41:34 GMT

That's what I considered first too. But I can't use my Last refresh table in a dax formula. I can't figure why.

It is actualized by a query that marks it =NOW() so it updates everytime the dataset is refreshed.

Any idea why, or how I could sove this ?

Anonymous — Mon, 20 Feb 2023 07:51:36 GMT

Hi Anonymous ,

Here are the steps you can follow：

1. Get "Last Refreshed Date" via the following link”.

2. Create measure.

Now = NOW()

Last Refreshed Date = MAX('Last Refreshed Date'[Column1])

Color = var _datediffminute= DATEDIFF( [Last Refreshed Date],[Now],MINUTE) var _2hour= 60 * 2 return IF( _datediffminute>_2hour,"red","green")

3. Visualizations – Callout value – FX.

4. Result:

Best Regards,

Liu Yang

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