Forum Discussion
Solved
Revenue score between two parameters from another table
Hi guys, I am trying to add a score (from parameters in another table) based on the expected year revenue. Current result in Matrix: Expected result: Dataset, Table Param...
Hi,
Write this calculated column formula in the Revenue table
Score = CALCULATE(MAX('Score parameters'[Score]),FILTER('Score parameters','Score parameters'[Item category]=EARLIER(Revenue[Item category])&&'Score parameters'[Revenue min]<=Revenue[Expected year revenue]&&'Score parameters'[Revenue max]>=Revenue[Expected year revenue]))Write this measure and drag it to the visual
S = MAX(Revenue[Score])Hope this helps.
Ashish_Mathur Thank you so much!
You are welcome.