Forum Discussion

eric98's avatar
eric98
Helper II
3 years ago

Refreshed Date

Hello everyone, 

My boss ask me to do something that I think impossible but maybe I'm wrong so thanks in advance for your help. 

 

Do you think that it's possible, after and refresh of a dataset in Power BI Desktop or Service, to keep the date of the last refresh if the dataset doesn't have new records ?

 

For example :

  • If I publish my report to Power BI Service today, the last refresh date will be today. 
  • If tomorrow I refresh the report through the service and there is no new record, I will have yesterday date. If there are new record, I will show today's date.

Thank in advance for your help.

 

Need Help

2 Replies

  • onurbmiguel_'s avatar
    onurbmiguel_
    Power Participant
    3 years ago

    Hello, 

    You need to crate a measure "Max Date" thar looks at you fact table and return the last date. 

    Example: 

     

    Max Date =  
CALCULATE(
    MAX('Fact_table'[main date]),
    all('Fact_table')
)

    please try

     

    Best regards

    Bruno Costa | Responsive Resident

     

    Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

    Take a look at the blog: PBI Portugal 

     

    • eric98's avatar
      eric98
      Helper II
      3 years ago

      I forget to notice something, I don't have any date column in my tables.