Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Good Morning
I am looking for help in setting target number based on period filter with value of last year, below is my scenerio
I select date from 1st sep to 30th sep
i got 2 values day by day - current year sales and last year sales
lets say last year total sep is 10,000 &
current year so for MTD(19 days) is 6,000
now my target is 4,000 for next 11 days
i want daynamic formula how this could be fixed in per day.
also i would like to clear based on my period selected the value should be changing.
thanks in advance.
Solved! Go to Solution.
Hi,
I think a bracket is missing. Try this
=-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |