COmissions by date

[dpicinin]

 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

[v-jayw-msft · Accepted solution]

Hi @dpicinin ,

Please check the formula:

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

Best Regards,

Jay

[Anonymous]

d after create this measure

com rate =

var activdate=selectedvalue('UB Data'[Date])

return

calculate(max(Comm[Comm]),'Calendar'[Date]>=activdate&&'Calendar'[Date]<=activdate)

[dpicinin]

Thanks for your time James.

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

Urner Barry.pbix

[Anonymous]

llo

just insert your calendar date instead of UB date date