Forum Discussion
Excel Column Changes in Power query
Hello Power Users, I'm trying to work on an excel data and i'm loading the excel to Power BI and I would like to change the column name every month. Example data looks like below. When the ...
Hi, Ainala ;
You could unpivot in power query.
Then in desktop create a column by dax.
Column = IF(EOMONTH([year-mon],0)<EOMONTH(TODAY(),0),"Past",FORMAT([year-mon],"mmm-yy"))then add a sort column.
sort = IF(EOMONTH([year-mon],0)<EOMONTH(TODAY(),0),1,RANKX(ALL('Table'),[year-mon],,ASC,Dense)+1)
add a matrix visual.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yalanwu-msft I have do them in Power query itself. The data changes in the excel and the power bi data load would break because of the column changes. is there a way to do this in Power query and filter them out.