Forum Discussion
Target Setting vs last year
Hi,
I think a bracket is missing. Try this
=-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)
Do you want to divide the difference by the remaining days in sep and display under CY sales column? can you please explain... also can you put the expected result in table format for better understanding?
Thanks
Raj
Hi Rajendra
as you see in the picture which i have shared earlier it shows negative value which is difference what i am looking is that based on this value which is my target i want a formula/calculation which shows me based on the remaining days here we have period of september so 11 days
so today the table shows like this
Current year :- 3,214,649
Difference :- 1,931,687
now remaining days for sept is 10 days
logical answer is 1,931,687/10 = 193,687 - i want this value to be daynamic.
i hope its clear now
Hi Arif270182
Can you please share the data and the pbix file you have so that a solution can be attempted.
Cheers
CheenuSing
Hi CheenuSing
Thank you - as i upload you pic of what i am excatly looking for let me breif you
in terms of sales we have comparision to last year so current year MTD vs complete month last year, so as you can see in pic i have negative (sales difference) i want to divide this value with remaining days of month so here it would be 9, so basically it would be 1931687/9 days ..... hence my requirement is i want this calculation automated from calculation/ formulation/ ? or i don't know how it can be .. i hope i have explained u
Difference table
Hi,
Assuming Sales Diff is a measure, write this new measure
Measure=-[Sales Diff]/(EOMONTH(TODAY(),0)-TODAY())+1
Hope this helps.