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

    Hi Greg_Deckler,

     

    I do have the above 2 columns as measures also. 

    I also have this calc column & measure to get the difference between the 2. Surplus/Deficit 2018 = SUM(CarersList[Made Active in 2018C]) - SUM([Made Inactive in 2018C])

     

    The problem is how do I show this for each week of the year? The 2 columns A & B use different date fields.