Forum Discussion
compare data with different dates
Hi there, I need to create a report on the accuracy of the orderbook from last month compared to actual sales for this month and can't get my head around a solution. Your help is highly appreciated. ...
123abc Thank you very much. There is one last issue now:
When I drop both of my measures (Actual Sales and expected Sales from Orderbook) in a matrix now, the orderbook measure is not split by Project ID, there is only a total.
The dim table for Projects has an established relationship to both fact tables (Actual Sales and Orderbook).
Do you have some wisdom to share?
| Project ID | Act Sales Jan 2024 | Sales from Orderbook Dec 2023 for Revenue Recognition Period Jan 2024 |
| ABC | 30 | |
| DEF | 50 | |
| GEH | 10 | |
| IJK | 20 | |
| Total | 110 | 120 |