User Profile
Kronhjort
Frequent Visitor
Joined 7 years ago
User Widgets
Contributions
Forecast consisting of actual + forecast filtered by FiscalYear
Hello I am working on a forecast model for Co2 reductions. I have used this method from SQLBI before: https://www.sqlbi.com/articles/showing-actuals-and-forecasts-in-the-same-chart-with-power-bi/ It has been working well but, in this case, I want to use it on FiscalYear. I expect to get FY22 to consist of actual data until 15 October 2021 and then forecast for the rest of the FY. This screenshot clearly shows that it is not happening: A detailed dive into the data shows that Remaining Forecast is blank in the rest of FY or FQ where actual data is present: I am sure this is a simple mistake related to the filter/keepfilter in remaning forecast. I cannot seam to get head around it. An important detail might be that FiscalYear is sorted by FiscalYearNum. Therefore, both must be a part of a filter. I have attached a link to a PIBX file with dummy data and relevant measures Link to file on Wetranfere
