Forum Discussion
Helper IConvert Rows in Columns
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.
Community ChampionI misunderstood. Thought your input was your output. In that case, you can:
1. Place ID, Name and Status in a table visual
2. Create these two measures and place them in the table visual:
Actual =
CALCULATE ( SUM ( InputT[Amount] ), InputT[Salary type] = "Actual" )Benefit =
CALCULATE ( SUM ( InputT[Amount] ), InputT[Salary type] = "Benefit" )The result will look like:
|
|
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. |
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
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.