Forum Discussion
Measure without unpivot data?
Dear all users, Currently this is my problem, - I have a data of thousands of Customers with visit plan from Monday to Saturday on a weekly basis -data structured horizontally per customer (like t...
Anonymous Thanks for your reply and suggestion,
I do understand can use unpivot , however it makes the data a little more heavy. Especially when refreshing the data model,
Well, either you'll pay the price at refresh time or query time - you have to choose which one is more important to you.
Secondly, please note that fact tables should be narrow and long, whereas dimensions should be wide and short. That's the rule.
Do not ever be tempted to cut corners with models in PBI. If you do and the design is not correct, you'll be (very) sorry rather sooner than later. You've been warned.
Best
Darek