Forum Discussion
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...
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
Apologies, column 2 is the date the case is created.