Forum Discussion

hhdez's avatar
hhdez
Regular Visitor
4 years ago
Solved

Group by Measure - Calculated categories

Hi, I am running an analysis on some sales figures, and I have the following table:   Product       WoW Delta    WoW Category A                     250                Increase B                 ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi hhdez ,

     

    You will need the [WoW Category] to be a column.
    Then you could use CONCATENATEX() function to create a new category group.

    Column = CONCATENATEX(FILTER('Table','Table'[WoW Category]=EARLIER('Table'[WoW Category])),'Table'[Product],",")

     

    Best Regards,

    Jay

jaipal's avatar
jaipal
Resolver III
4 years ago

hhdez you don't need a measure here. Just add your columns in correct fields.

 

let me know if it doesn't work

 

 

 

hhdez's avatar
hhdez
Regular Visitor
4 years ago

Hi,

I tried doing this but I can't seem to be able to move it 'WoW Category' as a row since it is a measure I calculated. Do you know if there is a way around this?