Forum Discussion
Dynamic pop up warning
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 hi...
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 SourceResult：
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
VahidDM
Super User
Super UserHi 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!!