Forum Discussion
Simple model not doable?
We have a very simple model with Partners, PartnerSales, PartnerRebates (see below). There is also an MyCal = CALENDARAUTO() table for filtering calendar - related data. What we need to see...
Anonymous ,
Have you tried "Pivot" and "Unpivot" in query editor? You may also refer to the tutorial below:
https://www.youtube.com/watch?v=OYM26ZytimM
Regards,
Jimmy Tao
This has nothing to do with data transformation when importing into the model. Maybe it was not clear enough in the question.
The question is purely being UNable to include data from other table when using calculated pivot tables.