Forum Discussion

ethanlsaul's avatar
ethanlsaul
Helper I
4 years ago
Solved

Pivot/Unpivot Data

Hello,   I have tried every combo of pivot, transpose, unpivot. I want my data to go from    Product Plant Qty 123 US10 100 123 US20 200 123 US30 111 456 US10 26 456 ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, ethanlsaul ;

    You could use pivot it.and the seting as follow:

    The final show:

     


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi ethanlsaul 

 

What you could do is to create a measure and where it finds a blank to replace it with zero as shown with the example below

 

Qty (With Zeros) = IF(ISBLANK('Table Name'[Qty]),0,SUM('Table Name'[Qty]))
ethanlsaul's avatar
ethanlsaul
Helper I
4 years ago

Not exactly-- it seems like in the field after isblank it needs another measure, which i dont have.