Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to Solution.
cacculate(divide(),keepfilters(calendar[date]<=today()))
cacculate(divide(),keepfilters(calendar[date]<=today()))
It worked!!
Thank you so much😅
User | Count |
---|---|
42 | |
28 | |
23 | |
18 | |
15 |
User | Count |
---|---|
54 | |
35 | |
18 | |
17 | |
15 |