09-15-2022 01:49 PM - last edited on 05-24-2023 12:51 PM by JackLacava
T#PeriodPrior1(|!DRU_Year!|):Name(April 30, 2021)
The member filter above is not dynamic since I am hard-coding 2021 in the second column. How can I make the second column be a prior period based on the first column?
Solved! Go to Solution.
09-15-2022 02:18 PM
Hi DGC: does the T#PeriodPrior1(|!DRU_Year!|) resolve to a full year time period? If so, you can use :Name(April 30, |MFTime|)
Cheers -DB
09-15-2022 02:18 PM
Hi DGC: does the T#PeriodPrior1(|!DRU_Year!|) resolve to a full year time period? If so, you can use :Name(April 30, |MFTime|)
Cheers -DB
09-15-2022 02:25 PM
Hi, thank you! That worked!