Need help on calculations

Question

Hello&nbsp;I need to have the Last Dec Sales Qty to be Dec Qty of previous year.&nbsp;Ie.&nbsp; Eg. from Jan 2021 to Dec 2021, I have to have another column indicating Dec 2020 Sales Qty.&nbsp; Based on my below scenario, Dec 2020 the sales qty is 200.&nbsp; So that's why the Dec Qty is 200 from Jan 2021 to Jun 2021.&nbsp; Thanks.&nbsp;&nbsp;&nbsp;PeriodSales QtyLast Dec Sales Qty2020-Nov100&nbsp;2020-Dec200&nbsp;2021-Jan3772002021-Feb5442002021-Mar2982002021-Apr1002002021-May3002002021-Jun288200

jihwan_kim · Accepted Answer

&nbsp;Link to the PBIX file&nbsp;&nbsp;&nbsp;

Forum Discussion

Need help on calculations

2 Replies

Related content

MoM calculation

Calculation Help

Calculate Tooltips

Hour Calculation

Calculating with Filters

Period	Sales Qty	Last Dec Sales Qty
2020-Nov	100
2020-Dec	200
2021-Jan	377	200
2021-Feb	544	200
2021-Mar	298	200
2021-Apr	100	200
2021-May	300	200
2021-Jun	288	200