topic Re: How to Group the following Column (This Should Be Easy For You Guys) in DAX Commands and Tips

How to Group the following Column (This Should Be Easy For You Guys)

Anonymous — Mon, 08 Jul 2024 21:05:45 GMT

I cannot find a solution to this issue. I have a column called "ExtractedText", and every value in this column is one of the following values: (Blank), 00, 01, 10, 20, 21, 30, 31, 40, 41, 50, 60, 70, 80, 90. I need to group my rows using this column as follows:

(Blank) = Blank

00, 20, 21 = Direct

10, 30, 31, 40, 41 = Indirect

50 = RTDI

60, 70 = SG&A

80, 90 = Corp

When all is said and done, I need a slicer that slices the data 5 ways by Blank, Direct, Indirect, RTDI, SG&A, and Corp. Let me know if you have any questions. This should be simple for regular PowerBI users but is difficult for a new user like myself. Thank you.

Re: How to Group the following Column (This Should Be Easy For You Guys)

Anonymous — Thu, 11 Jul 2024 01:59:19 GMT

Hi Anonymous

Please try the following DAX:

Column = SWITCH(TRUE(), [ExtractedText] = BLANK(),"Blank", [ExtractedText] IN { "00" , "20" , "21"} , "Direct", [ExtractedText] IN {"10" , "30" , "31" , "40" , "41"}, "Indirect", [ExtractedText] IN {"50"} , "RTDI", [ExtractedText] IN {"60" , "70"} , "SG&A", [ExtractedText] IN {"80" , "90"} , "Corp","other")

Result:

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: How to Group the following Column (This Should Be Easy For You Guys)

Anonymous — Thu, 11 Jul 2024 13:21:08 GMT

That worked perfectly, thank you!