Forum Discussion
roscas
Helper I
Helper IConvert Rows in Columns
I need to convert rows to Columns. If you see the picture on the left, I have the data on the right of the result, could someone please help me with this?
or if you prefer to do this in PQ, you can pivot the Salary type column:
and choose Amount as the values column:
See it all at work in the attached file. (OutputT is the version in PQ)
Please accept the solution when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
roscasHelper I
Helper IHi thanks for your help, the solutions (formulas) are created on DAX?
Is there a solution to do on M (Power Query)? Thanks
AlB
Community Champion
Community Champion
roscas wrote:
Is there a solution to do on M (Power Query)? Thanks
looks like you have not seen my other message, have you?
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |