Shipping time weeks


'TRA01 Shipping Metrics by Week'.'Shipping Time (Week)'[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: Shipping Method] 

After applying this i am not getting data populated in shipping time week line item


  • @Brj73 

    You're on the right track, you're formula is correct, but you may have overthought the formula. Take a look at YEARVALUE function. This is a better function since its basically a LOOKUP on the time hierarchy. make sure the TRA01 values are showing up.

    YEARVALUE('DAT02 Shipping Metrics'.'Shipping Time (Weeks)')

  • Brj73

    Thanks i got it 

    I had not applied formula in TRO1 shipping metrics by week so it was empty and not populated 

  • Hi I used the function you provided but it is not working for me because of 'level mismatch on common dimension'.