topic Show last year data of Current month in App Development

Show last year data of Current month

Sgiri — Tue, 25 Feb 2020 19:07:39 GMT

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.

Re: Show last year data of Current month

dplr-rn — Tue, 25 Feb 2020 20:22:26 GMT

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)

Re: Show last year data of Current month

Sgiri — Wed, 26 Feb 2020 14:32:13 GMT

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