Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

COmissions by date

 I have a table with the date the commissions changed. I need to make other calculations based on these commissions. But I was unable to show the percentage for the other dates. For example.. Aft...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please check the formula:

    Comm Rate = CALCULATE(MIN(Comm[Comm]),FILTER(Comm,Comm[Date]<=SELECTEDVALUE('Calendar'[Date])))

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
4 years ago

d after create this measure

com rate =
var activdate=selectedvalue('UB Data'[Date])
return
calculate(max(Comm[Comm]),'Calendar'[Date]>=activdate&&'Calendar'[Date]<=activdate)
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks for your time James.

     

    I did as you mentioned. But it didn't work. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Urner Barry.pbix