cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Power BI Monthly Update - June 2024

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

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors