Forum Discussion

jessicarocha's avatar
jessicarocha
Icon for Helper IV rankHelper IV
2 years ago
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...
Need Help
jessicarocha's avatar
jessicarocha
Icon for Helper IV rankHelper IV
2 years ago

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.

 

 

  • jessicarocha's avatar
    jessicarocha
    Icon for Helper IV rankHelper IV
    2 years ago

    lbendlin thank you so much! exactly what I wanted