Calculating Cost Projection for current month based on historic data

[Anonymous]

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 ?

[Greg_Deckler]

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

[Anonymous]

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 .