I have the following tables in SSAS tabular cube:
F_Sales : Invoice_key(FK), AMT
D_Invoice : Invoice_key(PK), Productline_key(FK)
D_ProductLine : ProductLine_key(PK), Prd_key(FK), ProductLine_Type, ProductLine_Date
D_Product : Prd_key(PK), Prd_Code
D_Situation : Situation_key, ProductLine_key(FK), Situation_Type, Situation_Date
User filters : Date
: He can choose or not a ProductLine_Type (optional)
I want to get the SUM(AMT) From F_Sales for every Prd_Code having the most recent ProductLine_Date with the associated Productline_Type filtered by Situation_date <= filter date chosen by user, for example:
New contributor