How to display last refresh date for only weekdays

[sreddy47652]

Hi Team, I need some help on dax to display last refresh date as Previous day, for example if you open the report on Monday then it should displat last refresh date as Friday(Excluding Weekends) and same way i want to display data as last friday. So can anyone help me how to accheive on this.

1. I need to display tile as last refresh date as previous day.

2.I need display data on kpi or card for previous day based on refresh.

[Anonymous · Accepted solution]

Hi @sreddy47652 ,

1. You can use DateTime.LocalNow() in Power Query Editor to catch the last refresh date.

For reference: Add last refresh date to a Power BI report - Azure DevOps | Microsoft Learn

2. Then publish your report to Power BI Service and then configure the schedule refresh only on weekdays.

For reference: Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

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