Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I have created time intelligence calculation groups MTD, YTD etc and all measures are working except the onces where i want to show the number of working days completed.
I have a seperate table with the just the previous working day in
Working days = sum(DateTable[is_workday])
Working Days Completed = calculate([Working days], DateTable[PKDate] <= max(Previousworkingday[previousworkingday]))
Can anyone point me in the right direction?
Solved! Go to Solution.
Fixed it by using a flag in the date table for all dates up to previous working day
Working Days Completed = calculate([Working days], DateTable[UPtoPD]=1)
Fixed it by using a flag in the date table for all dates up to previous working day
Working Days Completed = calculate([Working days], DateTable[UPtoPD]=1)