Forum Discussion

android1's avatar
android1
Post Patron
8 years ago
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...
Need Help
  • android1's avatar
    android1
    Post Patron
    8 years ago

    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