Forum Discussion
VuongLM93
Helper III
7 years agoMeasure 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...
parry2k
Super User
7 years agoVuongLM93 if you don't want to unpivot your table, yes, you need to create measure for each day. If table is unpivoted then you need to create one measure and if there are any subsequent measures like compare from last week, compare with last year etc, it will be couple of measures but if you keep the data the way it is, any subsequent comparison will need measure for each day and it will be too many measures. In my opinion, unpivot is the way to go.