Splitting a Table into two based on the value of a column

[anmsharma]

Hi Team,

I am learning the Power BI and Dax, posting here a very basic question.

I have a requirement where a table "CommCost" which contains the communication expense data for the "Drivers" and "Owners" based on their geography is stored.

In MS Power BI. I want to Split this table in to two i,e, "CommCost_Drivers" and "CommCost_Owners". Could anyone suggest a way to accomplish this task.

If the column "Drivers" have the data then it should go to "CommCost_Drivers" else "CommCost_Owners".

Many Thanks,

Anmol

[v-huizhn-msft · Accepted solution]

Hi @anmsharma,

Please click "New Table" under Modeling on Home page, please see the screenshot below. 




Then type the following formulas to create two new table.

CommCost_Drivers=FILTER(CommCost,CommCost[Drivers]<>BLANK())
CommCost_Owners=FILTER(CommCost,CommCost[Drivers]=BLANK())

Please feel free to ask if you has other issue.

Thanks,
Angelia

[anmsharma]

Hi @v-huizhn-msft,

One basic question, please don't think am dumb..

How to sort the table as per a column values in these 2 splitted tables.

Your help would be very much appreciated.

Thanks,

Anmol

[anmsharma]

Hi @v-huizhn-msft Angelia,

Thanks a lot for the assistance. This worked greatly for me and served the exact purpose.

Regards,

Anmol