Create a new table in dax

[FRG]

Hi,

From this existing table:

Can I create a new table who would look like this? If it's possible, I would like to filter the row of the original table when User 2 is blank.

Thanks!

[amitchandak]

Union and summarize table should help you. Later you can add the index column in this new table. Example

Balance Sheet = union(SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales]),"Col2",sum(Sales[COGS]),"sort",COUNTROWS(Sales)),SUMMARIZE(Sales,Sales[Brand],"Col1",sum(Sales[Sales1]),"Col2",sum(Sales[COGS1]),"sort",COUNTROWS(Sales)))

[FRG]

Hi @amitchandak ,

do you have any sample data to share to show the original tables?

Thanks

[amitchandak · Accepted solution]

@FRG  I thought you will share a sample. Anyways. I created one and put down solution.

File

[parry2k]

@FRG I would like to ask what you are trying to achieve by creating this new table? May be the your needs can be addressed with DAX measure or may be transforming the data in power query.

[FRG]

Thanks @amitchandak , thats what I need!