Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
buithai108
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:

 

NameTemp ValuePrev ValueDate
01/01/2019A 8,154,159
02/01/2019A 8,440,583
03/01/2019A5,467,6875,343,627
01/01/2020A 10,862,462
02/01/2020A 6,470,157
03/01/2020A 6,250,878
01/01/2021A187,84521,960,681
02/01/2021A 8,718,120
03/01/2021A 5,993,100
01/01/2022A 12,234,775
02/01/2022A 9,988,616
03/01/2022A6,745,9049,733,571
01/01/2020B 4,513,172
02/01/2020B 3,609,276
03/01/2020B 2,075,878

 

THE EXPECTED OUT PUT IS

buithai108_0-1670296794857.png

 

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
amitchandak
Super User
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])

View solution in original post

2 REPLIES 2
buithai108
Frequent Visitor

Wonderful, thanks!

amitchandak
Super User
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])

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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