Forum Discussion
Aimeeclaird
Helper IV
Helper IVTarget vs Actual Values and variance
Hi, I have a list of targets per month. I want to show the actual total vs the target table, and also calculate the variance. Here is an example of my data. https://data2actionltd-my.sharepoint.c...
Hi,
Could you precise the strucure of the target table please? it is misssing.
Also you want to visualise it in a classic table?
AimeeclairdHi Kevin,
The example target table is on the first sheet of the example I attached here: https://data2actionltd-my.sharepoint.com/:x:/r/personal/aimee_laird_data2action_co_uk/_layouts/15/Doc.aspx?sourcedoc=%7BC45513C2-0B92-4DA7-87D8-2D6E29BBFF95%7D&file=Example%20Data.xlsx&action=default&mobileredirect=true
I'll want to show the actual vs the target for each month to date, with a variance line.
Hope this clarifies,
Many thanks,
Okay, is this okay :
Hope it is what you expect.
- Aimeeclaird
Hi Kevin
That looks like it would be a sensible output. Please can you share your pbix. file or calculations?