Need Help in grouping by value in a calculated table

[AmeenVanakar]

Hi,

I am trying to group unique invoices by their bill value. I tried the below formula but something doesnt seem to work & I am getting an error "Argument '16' in SWITCH function is required."

Bill Range =

SWITCH(

    TRUE(),

    'Unique Bill Number'[Bill Value]<=1000,"Below 1000",

    'Unique Bill Number'[Bill Value]>1000 && 'Unique Bill Number'[Bill Value]<2000, "1001 - 2000",

    'Unique Bill Number'[Bill Value]>2000 && 'Unique Bill Number'[Bill Value]<3000, "2001 - 3000",

    'Unique Bill Number'[Bill Value]>3000 && 'Unique Bill Number'[Bill Value]<4000, "3001 - 4000",

    'Unique Bill Number'[Bill Value]>4000 && 'Unique Bill Number'[Bill Value]<5000, "4001 - 5000",

    'Unique Bill Number'[Bill Value]>5000 && 'Unique Bill Number'[Bill Value]<10000, "5001 - 10000",

    'Unique Bill Number'[Bill Value]>10000, "Above 10000",

)

[Kedar_Pande]

@AmeenVanakar ,

Corrected formula

Bill Range =
SWITCH(
TRUE(),
'Unique Bill Number'[Bill Value] <= 1000, "Below 1000",
'Unique Bill Number'[Bill Value] > 1000 && 'Unique Bill Number'[Bill Value] < 2000, "1001 - 2000",
'Unique Bill Number'[Bill Value] > 2000 && 'Unique Bill Number'[Bill Value] < 3000, "2001 - 3000",
'Unique Bill Number'[Bill Value] > 3000 && 'Unique Bill Number'[Bill Value] < 4000, "3001 - 4000",
'Unique Bill Number'[Bill Value] > 4000 && 'Unique Bill Number'[Bill Value] < 5000, "4001 - 5000",
'Unique Bill Number'[Bill Value] > 5000 && 'Unique Bill Number'[Bill Value] < 10000, "5001 - 10000",
'Unique Bill Number'[Bill Value] > 10000, "Above 10000",
"Unknown" // Default value if none of the conditions are met
)

If this helped, a Kudos 👍 or Solution mark would be great!
Cheers,
Kedar Pande
www.linkedin.com/in/kedar-pande

[Jonvoge · Accepted solution]

Hi AmeenVanakar

I believe you simply need to remove the final comma after "Above 10000", in the line ''Unique Bill Number'[Bill Value]>10000, "Above 10000",'. 

That final comma makes the switch statement believe that more arguments are coming.

_____________________________________________________
I hope my comment was helpful.
If your question was answered, please mark your post as 'Solved' and consider giving me a 'Thumbs Up'.
Find me on LinkedIn, Sessionize, or my blog Downhill Data

[AmeenVanakar]

Problem solved! Thanks @Jonvoge