How to calculate the previous year sales comparison without date column?

[bourne2000]

Hi

I am having table below

I don't have month or order date. Hence I cannot create date table and use sameperiodlast year dax function.

I want to calculate the previous year sales comparison and need as below

Year	Sales	Previous year	Growth
2018	100	0
2019	600	500	500%
2020	900	300	0.5

Not sure how to do this without sameperiodlastyear dax function

Seems very simple problem, but can't do it

Anyone can advise?

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.