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

Need Help

Ashish_Mathur

2 years ago

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.

Forum Discussion

Revenue score between two parameters from another table

Related content

Parameter in summarize

notebook parameter

Parameters to fabric pipeline

Field Parameter Question

Revenue Calculations