Forum Discussion
Create a new table in dax
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!
5 Replies
- amitchandak
Super User
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)))
- amitchandak