cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper II
Helper II

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

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

1 ACCEPTED SOLUTION
Microsoft
Microsoft

Hi @anmsharma,

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


1.PNG

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

View solution in original post

3 REPLIES 3
Microsoft
Microsoft

Hi @anmsharma,

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


1.PNG

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

View solution in original post

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

Hi @v-huizhn-msft Angelia,

 

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

 

Regards,

 

Anmol

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors