I’m using this code block as is. I’m running prior period comparisons using ‘current_period_date’ and ‘current_period_week’. It works perfectly for current_period_date when I pivot on period and look at measure comparisons with prior weeks.However fo...