Forum Discussion
Target Setting vs last year
Hi,
I think a bracket is missing. Try this
=-[Sales Diff]/((EOMONTH(TODAY(),0)-TODAY())+1)
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.