Can i use Pivot transform for more than 1 measure?

#1

Hi,

I am using pivot transform to transform my data based on various brands for a partner (using partner id) . i have 2 measures current year revenue and previous year revenue.
Can i create a pivot transform ,pivoting my data on brand and grouping on partner id and values will be both current year and previous year revenue?

1 Like
#2

Hello @mitsu.mehta,

I don’t think it is possible using a single pivot transformation in the Dundas cube because you can select just one measure for this element. You have to work on the query side in this case or you can create another flow in the cube(it depends if you can match the data after).