Extract columns from Table and make new tables

[Anonymous]

Hi,

I have a table(attached) and I want to make 3 seperate tables out  of it. Table 1 : Date 1,Cash1. Table 2:Date2,Cash2 and Table 3:Date 3,Cash 3.

How can I extract specific coloumns and make these 3 seperate tables?

[MFelix · Accepted solution]

Hi @Anonymous ,

If you pick the same source file you can on the query editor remove the columns you don't want. On one table remove last four, on second table first two and last two, and on last table last 4 columns.

Your model will only save the final steps so no additional data.

Check PBIX file attach.

Regards,

MFelix