March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch 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)
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
114 | |
76 | |
57 | |
52 | |
44 |
User | Count |
---|---|
167 | |
117 | |
63 | |
57 | |
50 |