Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Group in Power BI

Hey there, 

 

I'm looking for a way to create the following Groups in Power BI.

 

Need Help
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    6 years ago

    You could use Power BI Groups, or perhaps a calculated column like:

     

    Column =
  SWITCH(TRUE(),
    [ID Account] = 2090,Sales,
    [ID Account] = 2130,Sales,
    [ID Account] >= 1000 && [ID Account] <= 2000,Sales,
    [ID Account] = 2120,RR.HH,
    [ID Account] = 2110,RR.HH,
    [ID Account] = 2140,RR.HH
  )

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    6 years ago

    You could use Power BI Groups, or perhaps a calculated column like:

     

    Column =
  SWITCH(TRUE(),
    [ID Account] = 2090,Sales,
    [ID Account] = 2130,Sales,
    [ID Account] >= 1000 && [ID Account] <= 2000,Sales,
    [ID Account] = 2120,RR.HH,
    [ID Account] = 2110,RR.HH,
    [ID Account] = 2140,RR.HH
  )