Forum Discussion
Pivoting and merging
Hi everyone.
Hope you all are doing great.
I got two pieces of data to visualize. One for sales and one for transactions. Records are weekly and placed in different sheets.
Transaction2022,Transaction2023 and Sales2022,sales2023.
I unpivoted the tables separately and merged them as Sales and Transaction.
I loaded them in Powerbi but when I tried to visualize the result it was repeated numbers.
I might be wrong during pivoting or merging or even connection with other tables.
Is anybody kind to support me?
First step is to bring your data into a usable shape. You list 2022 and 2023 data but your calendar ony covers 2023 - I would rethink that.
Next step is to adjust your data model
With that you can now create your visuals according to your needs.
2 Replies
First step is to bring your data into a usable shape. You list 2022 and 2023 data but your calendar ony covers 2023 - I would rethink that.
Next step is to adjust your data model
With that you can now create your visuals according to your needs.
Thank you do much for your support.
