Forum Discussion
Calculating incremental contribution
Hello Community, I have a case which to me is pretty tricky to get started on. I will explain the scenario and then finish off with some of my own thoughts on how to structure this. Scenario: ...
Thank you once again.
The [Product Rank] measure, would that have to be a calculated column?
HI BIanon ,
yes try with calculated column
Hello again,
I tried adding the ranking to my dimension via my DW as the calc. col was too much to run on my model.
The problem is, doing it this way removes the ability to slice on time since the value i am ranking on needs to change as the user moves the time slicer.
I can rank dynamically, but I can't find a way to then work with those rankings since EARLIER() only accepts a col ref
Do you have an idea for this?
Also, thank you so far for your time and knowledge