Forum Discussion
Target Setting vs last year
Hi,
I think a bracket is missing. Try this
=-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)
Hello
Apologies if it wasn't clear
what i mean now that we got accurate value for "target per day" i am looking ahead to how i could break this number more accurate based weekdays
so based on snaps shared in previous message we see our "target per day" is 197,991 (thats for the rest of the days to close september - which are empty cells of table) i hope this is clear.
now here is what i am looking for so 24th sep is Monday, 25th Tues, 26th Wed and so on,
so incase if i select/filter monday then based on remaining monday it shall give me "target per day" only for monday so like in the snap i had shared i have selected Wednesday so you can notice there is one empty cell in table i.e. 26th september so if you notice the value of "target per day" is showing 19,212 which should not be correct logically.
As per my understanding it should give me value of sales difference in this case coz we have only 1 wednesday.
i hope i have ellobrated it clear enough to make you understand if not then let me know if i could reach you in other mode of communication.
thank you
Hi,
Try this measure
=CALCULATE(-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1),ALL(Calendar[Weekday])
In the Calendar Table, there should be a weekday column. The weekday slicer should be created from the Weekday column of the Calendar Table.
Hi Ashish
thank you so much for extending your support but seems the formula isn't working as i have snaps for you below, i have table for CY Date where my weekdays column is created based on dates. please let me understand if had it written correct the formula ?
Hi,
I will need to look at your PBI file. Share the link from where i can download your PBI file.
Appreciate your support, i hope this would help you to get our solution.
https://1drv.ms/u/s!An1F3GPoODE4afZbGK_7kvcBQN8
Thank you
Hi,
That is a 174MB file. Please get it down to a couple of MB's and then share the download link.
Hi
Is it ok if i share with you clould page ?
No that will not help. I need the PBI file.
so how can i minimise the size coz there lots of other tables .....
Please see if you can get rid of unequired Tables and also reduce the number of rows.
hi
would you like to access my laptop to see the file coz i have no idea how i can reduce the table sorry about it
Hi,
That link is not accessible.
Apologies Dear I hope the below would work
https://1drv.ms/u/s!An1F3GPoODE4axa2eCndnibFAAI
Thank you
Hi,
When i click on Wedneday, the result of target per day and Sales Diff is the same. This is what you wanted.
Yes excatly but since now all wednesday are covered could you check for sunday if you can see the target would be same as sale difference ?
Hi,
My formula is correct. The problem seems to be with the relationships. It will take way too long to study all relationships. I wont be able to devote so much time.
Hi Ashish
Thank you, i really appreciate the effort you put for me to understand it, just i would like to know a general or logic how it would work if possible to share
Hi,
I really cannot say. It's too large a model.