Forum Discussion
_Aleksa_
6 years agoHelper II
Switch Formula Error
Hello, I am using the switch formula and I am getting the following error: "A single value for column "Pmt_Instruction_Cde" cannot be determined." I am puzzled because I am using exactly the...
- 6 years ago
if you need a measure try
Ind = var _Pmt_Instruction_Cde = MAX('Weekly Data'[Pmt_Instruction_Cde]) var _Days = MAX('Weekly Data'[Days from Report Date]) var _State = MAX('Weekly Data'[State]) RETURN SWITCH( TRUE(), RIGHT(_Pmt_Instruction_Cde, 1)="2" && _Days >=0 && _Days <31, "All States Overdue", RIGHT(_Pmt_Instruction_Cde, 1)="2" && _State ="CA" && _Days >=90,"Overdue", RIGHT(_Pmt_Instruction_Cde, 1)="2" && _State ="OR" && _Days >=60,"OR Overdue", "" ) - 6 years ago
Try this
Ind = SWITCH ( TRUE (), RIGHT ( 'Weekly Data'[Pmt_Instruction_Cde], 1 ) = "2" && 'Weekly Data'[Days from Report Date] = 0 && 'Weekly Data'[Days from Report Date] < 31, "All States Overdue", RIGHT ( 'Weekly Data'[Pmt_Instruction_Cde], 1 ) = "2" && 'Weekly Data'[State] = "CA" && 'Weekly Data'[Days from Report Date] >= 90, "Overdue", RIGHT ( 'Weekly Data'[Pmt_Instruction_Cde], 1 ) = "2" && 'Weekly Data'[State] = "OR" && 'Weekly Data'[Days from Report Date] >= 60, "OR Overdue", "" )
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂