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
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