Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    4 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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

  • VahidDM's avatar
    VahidDM
    Super User
    4 years ago

    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 

  • mh2587's avatar
    mh2587
    Super User
    4 years ago

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

    "⚠"

    )