New Columns from date & type

Power Query
1

Hi there,

I have been able to place the “Type” and “Date” column values under certain new columns in Excel using formulas, and would like some help to do the same in the PBI Query Editor.

The second sheet in the Excel file shows the results I am looking to achieve in Power BI. Hope you can help!

New Columns.zip (31.1 KB)

2

Hi Mark / @powerbideveloper

Example you can find at :
Example for powerbideveloper.pbix (30.1 KB)

Using custom columns & few M formulas + pivot transformation.

I follow your Excel logic - and use some duplicates column for pivoting purposes - to have similar output as your Excel.

Hope it helps.

1 Like
3

@mspanic

I really like your approach with this. It’s simple and easy to implement.

Thanks so much!!

1 Like