Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
JoelG28
Frequent Visitor

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

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 

 

JoelG28_0-1697457116931.png

JoelG28_1-1697457173725.png

Disclaimer: This data is ficticious

 

 

2 REPLIES 2
lbendlin
Super User
Super User

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...

Hi Ibendlin, 

 

Thank you for you response. 

 

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

 

Best, 

Joel

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.