Forum Discussion
Get data & calculate values in rows without applying UnPivot command
Hi PBI Experts, I have a large & complex data set which is cumbersome to UnPivot. Why no UnPivot - I tried splitting the table to unpivot, then Unpivot them and later join them all, however, not ge...
My colleague said that "Unpivot" has been done in the M Code that you shared + created a column for calculated value,
I want to avoid that unpivot since my actual data is huge with many columns / rows & I will end up performing many unpivots & then that join function of multi talbes is too complex to perform & I am unsucceful joining.
What I need is that I have a fixed "region" values as of now and that PBI does the commission calculation in same output format as if UnPivot was performed.
Waiting for a solution.
Thanks,
Chandan