Question please. How can I get data from source module using time range dimension to target module with model calendar time dimension?
Scenario: I need to get the beginning balance of FY18 from the module to be able to transfer it to the target module which calendar year starts with FY19. Please ss.
I tried this formula but I did not get the values.
Go to Solution.
Hi,Try using this formula on the line item "Beg Balance"IF ITEM(Time) = Time.'Jan 19' THEN 'ATR - Actual - PY-Beg Balance'[SELECT: Time.'FY18'] ELSE 0We should avoid hardcoding like I've done above, but let me know if this works and I will then explain how to remove the hardcodingRegards,Anirudh
View solution in original post
You need to use Lookup. See if this helps.
PY Year = PREVIOUS(ITEM(Time))