Forum Discussion
Solved
Show difference between 2 calculated columns filtered by week number
Hi, I have 2 calculated columns A & B. Column A returns the total number of workers whose [StartDate] is in 2018 -> Made Active in 2018C = CALCULATE(DISTINCTCOUNT(CarersList[CarerRef]),DAT...
android1,
Please check the dax in modified PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1NolAkqZQW95jsMkso4
Regards,
Lydia
Need to get a sense of what your raw data looks like. Extremely difficult to provide a good answer otherwise as I can only guess at how your data is organized.
Hi Greg_Deckler,
Here's a sample of my file -> https://www.dropbox.com/s/jwiomu1ss6xikc0/Workforce%20WIP%202.pbix?dl=0