How to refresh the data based on Yesterday's Date

[manishbhamare97]

Dear All,

I need your help in order to solve the below issue that I'm facing with Power Bi:

I have the columns in my data for Date, Plan (Count) , Actual (Count). I want it in a table format where I can show Yesterday's Plan vs Actual count. But during this, I don't want to consider Sundays and other Holidays. Also, the table should get automatically refreshed for yesterday's (working day) Plan vs Actual, I don't want to use manual slicer for that.

Date	Plan	Actual	Holiday/Workday
Monday, January 1, 2024	5	5	Workday
Tuesday, January 2, 2024	4	3	Workday
Wednesday, January 3, 2024			Holiday
Thursday, January 4, 2024	4	4	Workday
Friday, January 5, 2024	3	3	Workday
Saturday, January 6, 2024	5	5	Workday
Sunday, January 7, 2024			Holiday
Monday, January 8, 2024	5	4	Workday
Tuesday, January 9, 2024	5	4	Workday
Wednesday, January 10, 2024	3	2	Workday
Thursday, January 11, 2024			Holiday
Friday, January 12, 2024	2	2	Workday
Saturday, January 13, 2024			Workday
Sunday, January 14, 2024			Holiday
Monday, January 15, 2024			Workday

[Ashish_Mathur]

Hi,

Show the expected result very clearly.

[manishbhamare97]

Hi,

Below is my expected result:

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  In that PBi file, have an additional Calendar Table with a column indicating whether the date is a Holiday or not.

[lbendlin]

Have you considered using LASTNONBLANK instead?