Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Hi,
Show the expected result very clearly.
Hi,
Below is my expected result:
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.
Have you considered using LASTNONBLANK instead?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |