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

llo

 

just insert your calendar date instead of UB date date