Calculate achievement rate based on the criterion of up to today.

[olives]

Hi

I am trying to calculate the percentage of sales achieved rate, but I do not want to calculate for future days.

I have three tables: sales, goals, and calendar.
The sales date in sales and the target date in goals are related to the calendar date.
The formula to calculate the percentage of sales achieved is written like this.

Achieved rate= DIVIDE([Sales],[Goal])

  I appreciate any help.

[wdx223_Daniel · Accepted solution]

cacculate(divide(),keepfilters(calendar[date]<=today()))

[olives]

It worked!!

Thank you so much😅