Add entries in a column of summarized table

[crln-blue]

Hello!

I created a summarized column below:

It has only two columns of data and I'd like to add additional rows for the Category column. Below is my expected output.

Category	CF Activity
A	AA
B	AB
C	AC
D	AD
E (new row)
F (new row)

Is this possible? I need this for making a hierarchy (related question) where I'm using the Path function (based on previews answers here in the community, the categories should be in the same column with its items).

Thank for the help!

[mohammedadnant]

Hi @crln-blue 

Good day,

you can use Union and Row DAX to add new rows of data to a table, check this video to know how...

https://www.youtube.com/watch?v=EkndV5cWMR8

Thanks & Regards,

Mohammed Adnan

www.youtube.com/taik18

[crln-blue]

Will check this. Thank you!