Dynamic pop up warning

[Anonymous]

Hi All,

I have a report which is updated every day however there are times when there is no updates.
I have a last refreshed card on the report however users would like something more clear to highlight when the report has not ben updated.

Is there a way to link the pop up to the last refresh date so it dynamically pops up if there is no refresh for today? 

for example if the last refresh date is 18/07/2022 then the report today would show a pop up saying no update 

[Anonymous · Accepted solution]

Hi  @Anonymous ,

Here are the steps you can follow：

1. In Power Query – Home – New Source – Blank Query.

2. Click on the newly formed Query – Home – Advanced Editor.

3. Enter the following code into it.

let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source

Result：

Get the last refresh time:

4. Create measure.

Measure =
IF(
  YEAR( MAX('Query1'[Date Last Refreshed]))=YEAR(TODAY())&&
  MONTH(MAX('Query1'[Date Last Refreshed]))=MONTH(TODAY())&&
  DAY(MAX('Query1'[Date Last Refreshed]))=DAY(TODAY()),"Update","No Update")

5. Result:

If you need pbix, please click here.

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

[mh2587]

Update Pop up = IF([last refresh date]=TODAY(),"","Not Updated"&

"⚠"

)

[VahidDM]

Hi @Anonymous 

Create a measure like this:
Update Measure = if([last refresh date]=Today(),"Updated","Not Updated")

and use this measure in a card visual.

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

Appreciate your Kudos!! 

LinkedIn | Twitter | Blog | YouTube