Forum Discussion

SimoneOS's avatar
SimoneOS
Frequent Visitor
3 years ago
Solved

calculation group not working on a date based measure (working days completed)

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 t...
  • SimoneOS's avatar
    3 years ago

    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)