Forum Discussion
Solved
loop through a column using a condition to create a measure
Hello, I need help with a conditional measure. My dataset contains: - actual revenue in a monthly basis - plan revenue values. The plan is per quartile. We receive an average monthly val...
see attached
You may want to consider cleaning up your data model first. The fiscal calendar information needs to go into the "dim date" table and be removed from the fact table. The Calendar table needs to be marked as a Dates table.
Hi lbendlin,
thanks for the feedback. i do have the calendar table in a separated date dimension. I created a dummy file last friday and loaded in the sharepoint (link above).
I still used the date column as a PK to connect to the fact table in the dummy example but in my real model it is just a random index PK.
see attached
lbendlin thank you so much! exactly what I wanted