Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

First value become second value.

Hi  Please help me with DAX mentioned below.   Date Cat Value Expecting Result 21/03/2012 A 100 0 15/04/2016 A 200 100 10/102020 A 300 200 21/03/2012 B 1000 0 13/7...
General Comment
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you so much amitchandak