Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |