Forum Discussion
How to refresh the data based on Yesterday's Date
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 |
4 Replies
- lbendlin
Super User
Have you considered using LASTNONBLANK instead?
- Ashish_Mathur
Hi,
Show the expected result very clearly.
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.
