Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 same criteria with just different number of days in another measure and it works perfectly fine there.
Solved! Go to Solution.
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",
""
)
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 🙂
Hey @_Aleksa_ ,
what is the context of the DAX statement, are you creating
If you are creating a measure, and there is no row context than you have to wrap the column references inside an aggregation function like MAX.
Hopefully, this provides some new insights and helps to tackle your challenge.
Regards,
Tom
I was creating a measure orginally.
When I tried creating a solumn with the same statement it teruned only one result ratehr than 3 was I intended.
Also, when I incorporate MAX function it is giving me another error message saying:
"Too many statements were passed to the MAX function."
Thank you for the help!
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",
""
)
Thank you, this worked perfectly for a measure!!
Woudl you be able to provide an option for a column?
Thanks!
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 🙂
Thank you!!!!
Hi @_Aleksa_ ,
If the answer solved your problem, please consider accept it as a solution.
Best Regards,
Jay
Hi @_Aleksa_ ,
You will no need to use MAX() or SELECTEDVALUE() function to create column. Just use your or orginal code will work.
Best Regards,
Jay
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
76 | |
75 | |
53 | |
37 | |
32 |
User | Count |
---|---|
99 | |
56 | |
50 | |
43 | |
40 |