Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
95 | |
90 | |
35 | |
35 |
User | Count |
---|---|
154 | |
102 | |
82 | |
64 | |
54 |