The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
hi,
Please see below table. Could you help me, please?
I have | I have | I have | I have | I want to have | I want to have | |
region | atrybut | year | month | I want - data type | I want also | |
CM | sales 1 | 2021 | 2021 | 2021 | ||
CM | sales 1 | 2022 | 2022 | 2022 | ||
CM | sales 1 | January | January 2023 | |||
CM | sales 1 | February | February 2023 | |||
CM | sales 1 | March | March 2023 | |||
CM | sales 1 | April | April 2023 | |||
CM | sales 1 | May | May 2023 | |||
CM | sales 1 | June | June 2023 | |||
CM | sales 1 | July | July 2023 | |||
CM | sales 1 | August | August 2023 | |||
CM | sales 1 | September | September 2023 | |||
CM | sales 1 | October | October 2023 | |||
CM | sales 1 | November | November 2023 | |||
CM | sales 1 | December | December 2023 | 2023 | ||
CM | sales 2 | January | January 2024 | |||
CM | sales 2 | February | February 2024 | |||
CM | sales 2 | March | March 2024 | Q1 2024 | ||
CM | sales 2 | April | April 2024 | |||
CM | sales 2 | May | May 2024 | |||
CM | sales 2 | June | June 2024 | Q2 2024 | ||
CM | sales 2 | July | July 2024 | |||
CM | sales 2 | August | August 2024 | |||
CM | sales 2 | September | September 2024 | Q3 2024 | ||
next months | ||||||
PN | sales 1 | 2021 | ||||
PN | sales 1 | 2022 | ||||
PN | sales 1 | January | January 2023 | |||
PN | sales 1 | February | February 2023 | |||
PN | sales 1 | March | March 2023 | |||
PN | sales 1 | April | April 2023 | |||
PN | sales 1 | May | May 2023 | |||
PN | sales 1 | June | June 2023 | |||
PN | sales 1 | July | July 2023 | |||
PN | sales 1 | August | August 2023 | |||
PN | sales 1 | September | September 2023 | |||
PN | sales 1 | October | October 2023 | |||
PN | sales 1 | November | November 2023 | |||
PN | sales 2 | December | December 2023 | 2023 | ||
PN | sales 2 | January | January 2024 | |||
PN | sales 2 | February | February 2024 | |||
PN | sales 2 | March | March 2024 | Q1 2024 | ||
PN | sales 2 | April | April 2024 | |||
PN | sales 2 | May | May 2024 | |||
PN | sales 2 | June | June 2024 | Q2 2024 | ||
PN | sales 2 | July | July 2024 | |||
PN | sales 2 | August | August 2024 | |||
PN | sales 2 | September | September 2024 | Q3 2024 | ||
next months |
thank you in advance
Solved! Go to Solution.
Thank you for your answer, but I have fixed my problem by myself.
regards, Ewa
Hi @Ewa_28
The problem and what you want is not clear.
Please try stating again the problem and explain with a clear example what your desired result is.
Regards
Phil
Proud to be a Super User!
User | Count |
---|---|
86 | |
84 | |
36 | |
34 | |
34 |
User | Count |
---|---|
93 | |
79 | |
66 | |
55 | |
52 |