Get header date from each spreadsheet as column

[PowerOn_DP]

Hi All,

I have excel as source in which there are multiple sheets which I am combining as one table.

Each sheet has a header BT Score- Month Year which I want in the new column by formatting it to dd/mm/yyyy.

So, that I can join my Calendar dimension to this table to filter out particular period.

I checked but Custom columns doesn't helped in query editor.

Below is how data into query editor looks

And which I am trying to get the expected Column5 as below

Can we accoplish this? Please help 

Thanks

[mahoneypat · Accepted solution]

Please see this 3 min video for one way to do this.

Power BI - Shift N Fill Data Pattern - YouTube

Pat

[PowerOn_DP]

@Hi @mahoneypat 

This would be of some help definately, I will check this. 

Thanks