topic Re: Calculating Cost Projection for current month based on historic data in DAX Commands and Tips

Calculating Cost Projection for current month based on historic data

Anonymous — Tue, 14 May 2019 10:35:22 GMT

I have the cost of consumption of an online service upto the current date of a month ( suppose till 15th of April) . I want to calculate what the projected cost of that service for the end of the month will be, with the costs available till date. What query can I use ?

Re: Calculating Cost Projection for current month based on historic data

Greg_Deckler — Tue, 14 May 2019 12:36:41 GMT

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Re: Calculating Cost Projection for current month based on historic data

Anonymous — Wed, 15 May 2019 04:50:58 GMT

Sample Data :

Usage Start Date	Cost (in USD)
3/20/2019	1159.386
3/21/2019	1149.944
3/22/2019	1159.235
3/23/2019	1110.684
3/24/2019	1114.055
3/25/2019	1159.736
3/26/2019	1170.26
3/27/2019	1175.579
3/28/2019	1185.042
3/29/2019	1178.746
3/30/2019	1123.629
3/31/2019	1122.347
4/1/2019	1195.82
4/2/2019	1186.296
4/3/2019	1193.692
4/4/2019	1177.898

I need to calculate what the estimated total cost for April will be based on the above data .

I have been using the formula :

Predicted Monthly Cost = (SUM('Data_Table'[Cost]) / DAY(TODAY()) * 30)

But this doesnt give the right desired solution . At the end of the month , the actual cost must be nearly close to the predicted cost .