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
android1,
Please check the dax in modified PBIX file below.
https://1drv.ms/u/s!AhsotbnGu1NolAkqZQW95jsMkso4
Regards,
Lydia
That works great. Thank you.
USERELATIONSHIP needed in column B. Used with a Date Table.
Column B= CALCULATE(DISTINCTCOUNT(CarersList[CarerRef]),DATESBETWEEN(CarersList[DateLeft],DATE(2018,1,1),date(2018,12,31)),USERELATIONSHIP(MyDateTable[FullDate],CarersList[DateLeft]))+0