Forum Discussion
Interval Previous Date
Hello, I have forecasts quantites by dates (Forecast table). I want to be able to know what quantities were received (Orders table) before each date where there is a forecast quantity. I can't figure out how to have an interval from the forecast date to previous forecast date.
Please se my tables and the desired result. **The forecast dates are not always for consecutive months.**
Thank you
5 Replies
No need for involving the date table .
see attached.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
