Date Range With AGGR Function

[dineshm030]

Hi All,

I have created the Bar Chart with AGGR function with below expression.

Expression:

Sum(Aggr(Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}[Net Available]),Cell,ShiftDate))

if I select ShiftDate = '07/07/2021', The date Should start from '28/06/2021'  to '07/07/2021' and so on.

PFA...

Thanks in advance.

Regards,

Dinesh Kumar Mani.

[MayilVahanan · Accepted solution]

Hi

Try like below

Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}Aggr(Sum({<ShiftDate= {"<=$(=max(ShiftDate))"},FiscalMonth = p(FiscalMonth)>}[Net Available]),Cell,ShiftDate))

o/p: