Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
Anybody can help me on why this is not working. I am trying to get the sales for the last 12 months.
Num(sum({$<[Date]={'>=$(=AddMonths(Today(),-12)'}>}[Sales]),'#,##0')
Thxs,
Alec
It's missing a ')' to close the AddMonths function:
Num(sum({$<[Date]={'>=$(=AddMonths(Today(),-12))'}>}[Sales]),'#,##0')
It's missing a ')' to close the AddMonths function:
Num(sum({$<[Date]={'>=$(=AddMonths(Today(),-12))'}>}[Sales]),'#,##0')
Thxs sir!