Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to Create Multiple Custom Columns with Different Formulas in One Applied Step?

Hello,   I'll preface this by saying I am an intermediate Excel user who is still relatively new to both M-Code and DAX and I just started using Power BI.   I am currently working on building a q...
Need Help
  • BA_Pete's avatar
    BA_Pete
    4 years ago

    Hi Anonymous ,

     

    My first instinct would be to unpivot your [CurrentPeriod_X] columns.

    Multi-select all columns that are not [CurrentPeriod_X], then on the Transform tab, go to Unpivot Columns > Unpivot Other Columns.

    This will normalise your data for correct data model use, and will mean you only need to perform your polarity change on one column.

     

    Pete

BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Anonymous ,

 

My first instinct would be to unpivot your [CurrentPeriod_X] columns.

Multi-select all columns that are not [CurrentPeriod_X], then on the Transform tab, go to Unpivot Columns > Unpivot Other Columns.

This will normalise your data for correct data model use, and will mean you only need to perform your polarity change on one column.

 

Pete

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you very much BA_Pete!

 

Your solution worked great and I now understand how pivoting and unpivoting works within the query (somewhat). Have a great rest of your day!