Forum Discussion
Group multiple values from same and different columns
Hello! I have a database that has all the sales from a date, per Product and Currency, by 2 different companies. Data sample: Date Product Currency Company Value 01/01/2025 A USD...
Hi!
Many thanks for the step by step guide!
Sorry, im kinda new to powerBI. But when i was trying to follow your instructions:
Select the Date column.
Click on Transform -> Pivot Column.
In the Pivot Column dialog, select Company as the value column and Value as the aggregation.
I couldnt find the "Value" as the aggregation
But even so, the next step consists in selecting the date column again. Should i select all the dates or only one?
Select the Date column.
Go to the "Transform" tab and click on "Pivot Column."
In the Pivot Column dialog, select Company as the value column and Value as the aggregation
All dates means basically date column