cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Frequent Visitor

## Value related to next date

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

1 ACCEPTED SOLUTION
Super User

@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])

2 REPLIES 2
Frequent Visitor

Wonderful, thanks!

Super User

@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])

Announcements

#### Fabric certifications survey

Certification feedback opportunity for the community.

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors