Dax formula to filter

[Anonymous]

Hello,

I am trying to split the account table. Knowing that I cannot change the Data set. I would like to split it in different categories ( buy , make ,supply, the rest)

Buy = raw +pack + Purch. 3P

make = FFOH ...

Supply = bad goods Dist allowance ...

the reste =all the other account

Best regards,

Kerrout A

[davehus · Accepted solution]

Hi @Anonymous , Do you want to group them? If so, you can right click on the column field in the there is an option to create group.

Did I help you today? Please accept my solution and hit the Kudos button.

[Anonymous]

Not possible to group them. That's why I am looking for a DAx formula