Forum Discussion

Kashibaba's avatar
Kashibaba
Brass Contributor
Jan 14, 2020

power query insert blank columns ....

Hi all, I am doing a pivot in power query which then gives me data in week numbers as columns for each line of product. problem is that I want to keep 12 week numbers from starting number but query only loads week numbers exists in data range. for example if there is no data in a week that week number will not appear anywhere hence query will not load a column for that week number when doing pivot. 

is there any work around to always have 12 weeks starting form the lower week number regardless of data exists for each week or not. week numbers without data can come as blank columns.

 

any help will be appreciated.

 

Thanks a lot.

2 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    Kashibaba , you ma generate the list with all 12 weeks appending to you main query (all other fields could be nulls) and pivot on resulting query. 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    It would help to have some sample data in an Excel workbook.

Resources