QTD

[#1]

Hi Experts,

I would like to know how Quarter Till Date(QTD) logic wil work .

Can any one explain with some sample data.

Thanks

[Karim_Khan]

Pls check my MTD expression

=round(sum({<FiscalYear={'$(vPriorYear)'},Month={'$(vMaxMonth)'}>}[Net Bookings]))

QTD   expression

=sum({<FiscalYear = {'$(vCurrentYear)'}, Quarter = {'$(vQuarter)'},Month={'$(vMaxMonth)'},Date={'$(vMaxDate)'},Day={'<=$(vMaxDay)'},MonthYear=>} [Net Bookings])

[Karim_Khan]

Pls check my MTD expression

=round(sum({<FiscalYear={'$(vPriorYear)'},Month={'$(vMaxMonth)'}>}[Net Bookings]))

QTD   expression

=sum({<FiscalYear = {'$(vCurrentYear)'}, Quarter = {'$(vQuarter)'},Month={'$(vMaxMonth)'},Date={'$(vMaxDate)'},Day={'<=$(vMaxDay)'},MonthYear=>} [Net Bookings])