Forum Discussion

jwessel's avatar
jwessel
Helper II
3 years ago
Solved

Help with calculated column or measure

I  have a dataset...... simplified here: Case Number   Assistance     1 1/1/2023 Rent     1 1/1/2023 Util     2 1/1/2023 Rent     2 1/1/2023 Rent     3 1/1/202...
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    jwessel Maybe:

    Measure =
  VAR __Case = MAX('Table'[Case Number])
  VAR __Table = SUMMARIZE('Table',[Assistance])
  VAR __Count = COUNTROWS(__Table)
  VAR __Result = 
    SWITCH(TRUE(),
      __Count = 2, 6,
      MAXX(__Table, [Assistance]) = "Rent", 7,
      5
    )
RETURN
  __Result
Greg_Deckler's avatar
Greg_Deckler
Community Champion
3 years ago

jwessel Maybe:

Measure =
  VAR __Case = MAX('Table'[Case Number])
  VAR __Table = SUMMARIZE('Table',[Assistance])
  VAR __Count = COUNTROWS(__Table)
  VAR __Result = 
    SWITCH(TRUE(),
      __Count = 2, 6,
      MAXX(__Table, [Assistance]) = "Rent", 7,
      5
    )
RETURN
  __Result
jwessel's avatar
jwessel
Helper II
3 years ago

thanks Greg, I will give that a try.