Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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