Financials Testing.pbix (1.4 MB)
My model has a consignment header table that links to consignment sales, consignment detail, consignment costs etc but the important date field is CN_SALES.ORDER DATE not from the CN Header and CN_SALES.ORDER DATE links to the Date table.
My data sources are via direct query to a SQL database so I can’t use certain DAX functions.
Because of this I have used a SUMX and CROSSFILTER measure to retrieve field values from the other tables.
E.g. of measure
PUR Cost =
SUMX(CN_COST_HD, CN_COST_HD[Price]), FILTER(CN_COST_HD, CN_COST_HD[CCH_COST_CODE] = “PUR”),
I am worried that the use of so many SUMX will cause inefficiency in the model but I don’t know what else will work. Any suggestions would be gratefully received.
Many thanks Lizzie