Forum Discussion
userelationship
Hi Anonymous ,
in your statement you use ALL to remove the filter from the date table. I think if you want to work with date reference, you have to replace this with the USERELATIONSHIP.
mwegener I have tried this. I actually need to use two userelationships because request date and order date are both connected to the date table using inactive relationships.
But I am getting an error message:
Hi Anonymous ,
sorry I think I misunderstood your requirement and your DAX statement.
In my opinion, I would not do the date comparison of Order Date and Request Date using the date dimension.
What advantage do you see to do this via the date dimension?Hi mwegener What the formula is trying to do is to look at the request date (the date an order has been requested to ship) and look two months back to the order date. We are trying to see how accurate our forecasting is and this is the logic they want to use. So, if there are orders with requests dates in May, we would want to look at orders with order dates in March (two months back). However, the Orders table has a primary active relationship with the date table...using "due date". So in essence, the date table context on the orders table, at least for this particula formula, is using the wrong date context (due date instead of request or order date). I am trying to get the formulas to connect to the date table each with their respective date context (either request date or order date). Hope that makes sense?