If statement NULL

[jamiemcc]

Hi Guys,

How do i Only include the last 28 days using the If statement. Date is a dimension,If Date is not within the last 28 days its null.

=If (DateId = {">=$(=Max(DateId)-28)"} ,Date,null())

Jamie

[AshutoshBhumkar]

Hello,

Maybe below statement will help.

Expression : =If(Num(InvoiceDate) >=$(vMaxDate),Date(InvoiceDate),Null())

Variable for Max Date : =Max(InvoiceDate)-28 (Max Date in my data in 31-Dec-21).

Thanks,
Ashutosh