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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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