Value related to next date

[buithai108]

Hello,

Im new to Power BI, I would like to find the value next month time on the same case

I'm building a report from the data like below:

Name	Temp Value	Prev Value	Date
01/01/2019	A		8,154,159
02/01/2019	A		8,440,583
03/01/2019	A	5,467,687	5,343,627
01/01/2020	A		10,862,462
02/01/2020	A		6,470,157
03/01/2020	A		6,250,878
01/01/2021	A	187,845	21,960,681
02/01/2021	A		8,718,120
03/01/2021	A		5,993,100
01/01/2022	A		12,234,775
02/01/2022	A		9,988,616
03/01/2022	A	6,745,904	9,733,571
01/01/2020	B		4,513,172
02/01/2020	B		3,609,276
03/01/2020	B		2,075,878

THE EXPECTED OUT PUT IS

I have tried with the calculate and the lookupvalue function without any luck.

Hope that someone can be of help! 

Best regards

[buithai108]

Wonderful, thanks!

[amitchandak · Accepted solution]

@buithai108 , Try like

new column

next day = sumx(filter(Table, [Name] = earlier([Name]) && [Date] = earlier([Date])+1 ),[Prev Value])

Previous year same day =
var _day = date(year([Date])-1, month([Date]),1)
return
sumx(filter(Table, [Name] = earlier([Name]) && [Date] = _day ),[Prev Value])