Calculate the difference between Current and previous period

[Anonymous]

Hi Team,

How to calculate the difference between current and previous data as shown below.

Sample data:

Mem_id	Pol_period	rpt_dt	lec
96	17-18	Jun-19	100
96	17-18	Dec-19	200
96	18-19	Jun-19	300
96	18-19	Dec-19	100
96	16-17	Dec-20	200
96	16-17	Jun-20	300
96	15-16	Dec-20	100
96	15-16	Jun-20	200
96	14-15	Jun-18	300
96	14-15	Dec-18	100
96	13-14	Jun-18	200
96	13-14	Dec-18	300

Need to display in as shown below.

Regards,

Suresh Pantra.

[amitchandak · Accepted solution]

You can try in the following ways

last year same period = CALCULATE(sum(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date Filer]))

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date Filer]))
last MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date Filer],-1,MONTH)))

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date Filer])))

Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date Filer],1,QUARTER)))

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(('Date'[Date Filer])))

Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date Filer],-1,Year)))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[Anonymous]

Hi @amitchandak ,

Can you please share me the .pbix file.

Regards,

Suresh Pantra.