Measure for XTD Variance

Question

I am trying to create a measure to compare my actual daily values to my forecasted daily values to a dynamic date range.

For example, I have several sheets in my report that look at different date range views of the graph above. Some are YTD, some are QTD and some are snapshots of individual months.

The green line are the daily actuals and the black line is the forecast. I need a measure to essential compute the variance up until the latest data point of actuals and ignoring future days in the forecast.

v-piga-msft · Answer

Hi&nbsp;Anonymous,
For your scenario, could you please share some data sample which could reproduce your scenario and your desired output so that we could have a test on it and get the solution more quickly.
Best&nbsp; Regards,
Cherry

anonymous · Answer

v-piga-msft&nbsp;&nbsp;Hi Cherry,&nbsp;Here is a small sample of data that is in my data set.&nbsp;YearMonthDaySum of Net Forecast ProductionSum of Net Actual Production2019April1002019April2002019April3002019April4002019April5002019April6002019April7002019April8002019April90257.932019April100330.482019April1101301.872019April120.03702.182019April13170.04752.762019April14258.071555.372019April15339.191887.922019April16420.312274.542019April17611.272288.462019April18726.332915.122019April19814.973433.322019April20904.013528.042019April21993.473938.372019April221083.353540.842019April231173.73733.622019April241264.534251.152019April251355.875872.982019April261447.745677.792019April271540.176619.262019April281633.227455.362019April291909.779296.282019April302369.867735.632019May16754.029649.032019May26891.299605.512019May37660.639759.232019May48065.6110867.722019May58195.8310167.882019May68322.879944.312019May78433.1810478.112019May88541.4810476.032019May98579.1310316.172019May108592.311000.392019May118602.579784.222019May128613.2710675.462019May138628.29394.352019May148634.659059.492019May158631.339580.242019May168625.759351.242019May178561.469603.782019May188473.629241.262019May198387.929000.092019May208304.259211.222019May218222.54&nbsp;2019May228142.73&nbsp;2019May238064.76&nbsp;2019May247988.53&nbsp;2019May257913.98&nbsp;2019May267841.08&nbsp;2019May277769.75&nbsp;2019May287699.96&nbsp;2019May297631.61&nbsp;2019May307564.68&nbsp;2019May317499.13&nbsp;

Forum Discussion

Measure for XTD Variance

2 Replies

Related content

Dynamic Format DAX measure calculating variance

Budget, actual and variance matrix

Variance and Variance % between 2 measures

Variance bar chart

Stacked bar charts with variance

Year	Month	Day	Sum of Net Forecast Production	Sum of Net Actual Production
2019	April	1	0	0
2019	April	2	0	0
2019	April	3	0	0
2019	April	4	0	0
2019	April	5	0	0
2019	April	6	0	0
2019	April	7	0	0
2019	April	8	0	0
2019	April	9	0	257.93
2019	April	10	0	330.48
2019	April	11	0	1301.87
2019	April	12	0.03	702.18
2019	April	13	170.04	752.76
2019	April	14	258.07	1555.37
2019	April	15	339.19	1887.92
2019	April	16	420.31	2274.54
2019	April	17	611.27	2288.46
2019	April	18	726.33	2915.12
2019	April	19	814.97	3433.32
2019	April	20	904.01	3528.04
2019	April	21	993.47	3938.37
2019	April	22	1083.35	3540.84
2019	April	23	1173.7	3733.62
2019	April	24	1264.53	4251.15
2019	April	25	1355.87	5872.98
2019	April	26	1447.74	5677.79
2019	April	27	1540.17	6619.26
2019	April	28	1633.22	7455.36
2019	April	29	1909.77	9296.28
2019	April	30	2369.86	7735.63
2019	May	1	6754.02	9649.03
2019	May	2	6891.29	9605.51
2019	May	3	7660.63	9759.23
2019	May	4	8065.61	10867.72
2019	May	5	8195.83	10167.88
2019	May	6	8322.87	9944.31
2019	May	7	8433.18	10478.11
2019	May	8	8541.48	10476.03
2019	May	9	8579.13	10316.17
2019	May	10	8592.3	11000.39
2019	May	11	8602.57	9784.22
2019	May	12	8613.27	10675.46
2019	May	13	8628.2	9394.35
2019	May	14	8634.65	9059.49
2019	May	15	8631.33	9580.24
2019	May	16	8625.75	9351.24
2019	May	17	8561.46	9603.78
2019	May	18	8473.62	9241.26
2019	May	19	8387.92	9000.09
2019	May	20	8304.25	9211.22
2019	May	21	8222.54
2019	May	22	8142.73
2019	May	23	8064.76
2019	May	24	7988.53
2019	May	25	7913.98
2019	May	26	7841.08
2019	May	27	7769.75
2019	May	28	7699.96
2019	May	29	7631.61
2019	May	30	7564.68
2019	May	31	7499.13