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
Anonymous
Not applicable

First value become second value.

Hi 

Please help me with DAX mentioned below.

 

DateCatValueExpecting Result
21/03/2012A1000
15/04/2016A200100
10/102020A300200
21/03/2012B10000
13/7/2014B20001000
15/04/2016B30002000
06/062020B40003000

 

Thank you

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , Try a new column like

 

new column =
var _max = maxx(filter(table, [Date] < earlier([Date]) && [Cat] =earlier([Cat])),[Date])
return
maxx(filter(table, [Date] = _max && [Cat] =earlier([Cat]) ),[value])

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@Anonymous , Try a new column like

 

new column =
var _max = maxx(filter(table, [Date] < earlier([Date]) && [Cat] =earlier([Cat])),[Date])
return
maxx(filter(table, [Date] = _max && [Cat] =earlier([Cat]) ),[value])

Anonymous
Not applicable

Thank you so much @amitchandak 

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.