LOOKUP's for the DAT02 PY Revenue to CY Module Level 3 Model Build
I have tried almost everything and have been stuck on this part of the model build or a day now. I have changed my dimensioned and tried to get them to match and still not working. I'm trying to pull in Actuals from the DAT 01 into the DAT02 and Looking up LT Account A1 inthe SYS03 Module. Please advise.
Formula: 'DAT01 Historical Data'.'2019 Actual Sales'[LOOKUP:'SYS03 Account>Product Details'.'A1 Account']
Dimensions of DAT02
Dimensions of SYS03