Forum Discussion

rzilli's avatar
rzilli
Frequent Visitor
3 years ago
Solved

Help Calculate Bonus with % margin range

Hi Guys

 

I need some help on this, I have the table below with the % margin achieved variance each 0.5% we pay a different bonus ( as the table below) 
paid monthly

I am trying to isert a formula to calculate by month, I tried If( didnt work)

 

 

 

Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    3 years ago

    rzilli Making some assumptions, seems like it should be something like:

    Measure =
  VAR __Margin = 'Table'[Margin] //whatever you use to calculate your margin
RETURN
  MAXX(FILER('Margin Table',__Margin >= [Min %] && __Margin <= [Max %]),[Bonus Big Shop])

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    3 years ago

    rzilli Making some assumptions, seems like it should be something like:

    Measure =
  VAR __Margin = 'Table'[Margin] //whatever you use to calculate your margin
RETURN
  MAXX(FILER('Margin Table',__Margin >= [Min %] && __Margin <= [Max %]),[Bonus Big Shop])
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi rzilli,

    Did Greg's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

    If that also doesn't help, please share more detailed information to help us clarify your scenario to test.

    How to Get Your Question Answered Quickly 

    Regards,

    Xiaoxin Sheng