Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
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
I hope this would work
https://onedrive.live.com/?cid=383138E863DC457D&id=383138E863DC457D%21106&parId=root&o=OneUp
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |