Forum Discussion

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost Patron
6 years ago
Solved

Calculation support

Hi Gents,   Need your support with the following:   I have this table     Type P01 P.. P12 CountryX Sales Coffee       CountryX Sales Margin Coffee       CountryX Sal...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    6 years ago

    Hi, abukapsoun , how about calculating number of quarter after unpivoting P01-P12. The sales data then is tranformed to a one-dimensional table. A pbix file is attached for your reference.

CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
6 years ago

Hi, abukapsoun , how about calculating number of quarter after unpivoting P01-P12. The sales data then is tranformed to a one-dimensional table. A pbix file is attached for your reference.