Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi experts,
I have following information in my table
In my report, I have a filter that lets me choose my month and now,I would like to show 6 KPI's which are the sales for each region, both for the chosen month as for the "chosen month -1".
I managed to set the 3 KPI's for the sales per region, per month but I cannot find a solution for the previous month.
Any idea how I could do this?
Thanks in advance for your help & time
Perhaps
=Avg({$<[Region] = {"A"}, Month = {"$(=Date(AddMonths(Month, -1), 'MMM-yy'))"}>} Sales)
Maybe ,
Avg({$<[Region]={"A"}, month = {"=num(month-1)"} >}[Sales])
Perhaps
=Avg({$<[Region] = {"A"}, Month = {"$(=Date(AddMonths(Month, -1), 'MMM-yy'))"}>} Sales)
Thanks Jonathan & Vishnu!
It worked 🙂