Dynamic Prior

DCarrillo
New Contributor III

DGC_0-1663262366454.png

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?

1 ACCEPTED SOLUTION

db_pdx
Contributor III

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

 

View solution in original post

2 REPLIES 2

db_pdx
Contributor III

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

 

DCarrillo
New Contributor III

Hi, thank you! That worked!