Forum Discussion

acbg's avatar
acbg
Icon for Resolver III rankResolver III
8 years ago
Solved

Pivot multiple month columns

I have a dataset which comes across normalized with 3 different months under month column.    This needs to be pivoted has columns in a table for users.   Issue is the 3 months changes.    I ca...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi acbg,

     

    Based on my test, you should rebulid your visual here. As I can reproduce your issue here. Or if you just add rows in your data source, then everything should go well.

     

     

    Regards,

    Frank

acbg's avatar
acbg
Icon for Resolver III rankResolver III
8 years ago

v-frfei-msft

 

if we use the actual month name instead of Month 1 then it does not work.

 

For example: Instead of Month 1,Month 2, Month 3. Use Jan, Feb and Mar.

 

Then re-name the months as Apr, May, Jun. in the dataset and reimport it. M code works when we pivot it with new column names as Apr, May and Jun.

 

But the end graph/table in Power BI do not auto-recognize the change in column names from Jan, Feb and Mar to Apr,May, Jun.

 

It errors out as its unable to find Jan, Feb and Mar columns.

v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi acbg,

 

Based on my test, you should rebulid your visual here. As I can reproduce your issue here. Or if you just add rows in your data source, then everything should go well.

 

 

Regards,

Frank

  • acbg's avatar
    acbg
    Icon for Resolver III rankResolver III
    8 years ago

    v-frfei-msft Thank you for the response.

     

    I was hoping there is another way of automatting it.

     

    I have the months changing on a weekly basis and would like for it to be automatted instead of fixing it each week.

     

    Since I can't find a automatted solution, I have went back to calling the months Month1, 2 and 3 instead of the actual names.