Pivoting and merging

[nbmalla]

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?

https://xgf.nu/K21XS

[nbmalla]

Thank you do much for your support.

[lbendlin · Accepted solution]

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.