Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
In a table I wanted to show last year January Data when the current month is feb. When it is march then I have to show last year (2019) January and February sales amount and when it is April then the table should update for January, February and March 2019 data. Likewise for all other months.
I have a field called [Eff_Date.autoCalendar.Date] which has data like 1/1/2018 till 02/28/2020.
Thanks.
share an example of the table you want. it not completely clear.
but on a high level you could use set analysis. assuming only measure you want is last years data use a measure like below
e.g. Sum({<Date={">= $( YearStart(addyears(today(),-1)) )<=$(MonthEnd(addmonths(today(),-13)) )"}>}Sales)
Hello ,
I want to show my table like the below I got sum(sales) for 2020 as expected but I could not achieve the sales of 2019.
Any solution to solve my issue.
Date (MM/DD) | Sales of 2020 | Sales of 2019 |
02/2020 | Jan 2020 Sales | Jan 2019 Sales |
03/2020 | Jan, Feb 2020 Sales | Jan, Feb 2019 Sales |
04/2020 | Jan, Feb, March 2020 Sales | Jan, Feb, March 2019 Sales |