Creating a forecast based on previous weekday averages: Total in table not Showing

[JoelG28]

Hi PBI Community, 

I am hoping someone will be able to help me with the below issue. 

I am currently trying to make a formula which uses actuals up to today(), and then predict the rest of the month, however giving each weekday a specific forecast value. This forecast value will be specific to the weekday, averaging over the last 31 days. 

The issue I'm running into, is that my actuals are included within the total, but my forecast figures are not. 

I have tried both this approach using DAX, as well as creating calculated tables/ columns and have had no luck so far. 

Any tips would be appreciated 😊

Best, 

Joel 

Disclaimer: This data is ficticious

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[JoelG28]

Hi Ibendlin, 

Thank you for you response. 

Please see the Wetransfer link to the sample test data. https://we.tl/t-5dWJR1y87N

Best, 

Joel