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.. After 01/02/2014, I want to show 2.5% in every line not only on the day it changed. Until the value of the commissions' changes again.

 

 

 

 

Urner Barry.pbix

 

 

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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

  • 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