Forum Discussion
Difference per Month
Hello,
I am lost by creating a constant value for a planned period, and therefore, I am looking for an alternative way:
1. May constant value should be the December Value. Therefore, I created a measure with Calculate(Sum(...[Scenario]="Budget", [Month]="December"). This worked fine.
2. Now, I want to calculate for each month the difference to December Value so: Difference = [December]-[January]
3. I will now calculate the constant as Calculate(Sum([StockEnd]), [Scenario]="Budget")+[Difference].
So hopefully, I will get for each month (when I use the month on my axis) the same value.
Is this possible, and if yes, how is the Formular for 2. looking? I do not have a glue, how to tell im this
3 Replies
Pfoerster , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in a table format?Refer this video on actual and target can help you -https://youtu.be/yPQ9UV37LOU
Appreciate your Kudos.Yes, of course:
Here is my Source Table:
Product Scenario Month Year Volume A Budget January
2020 100 A Budget February 2020 125 A Budget December 2020 300 A
Actual January 2020 200 A Actual Februar 2020 280 B Budget January 2020 140 B Budget February 2020 70 B Budget December 2020 30 B Actual January 2020 80 And this should be the output in my visual:
So I will get the Scenario "Actual" as columns, and for "Budget", I have a constant line of December Value (The 100 of Product A in January has to be changed into the 300 out of December).
The problem behind: For Data import, I have wrong monthly figures in this column. Only December is correct and valid.
Hi Pfoerster ,
I tried to reproduce your senario,but failed,could you pls provide more details about how to get the result you expected?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
