Forum Discussion

DiegoSRNA's avatar
DiegoSRNA
Frequent Visitor
4 years ago
Solved

DAX Evolution Measure

Hi all, i need some help on my DAX formula because i don't know how to implement it. I have differents row sales value split by dates: Date Value 04/02/2022 20 05/02/2022 21 06/02/2...
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi DiegoSRNA 

    You can create a measure to return the value of N days ago . In the below formula , -2 means 2 days ago.

    N days ago = CALCULATE(MAX('Table'[Value]),DATEADD('Table'[Date],-2,DAY))

    Then create a measure to count the diff between the specific day and N days ago .

    diff = SELECTEDVALUE('Table'[Value])-CALCULATE(MAX('Table'[Value]),DATEADD('Table'[Date],-2,DAY))

    The final result is as shown :

    I have attached my pbix file , you can refer to it .

     

    Best Regard

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

DiegoSRNA's avatar
DiegoSRNA
Frequent Visitor
4 years ago

Hi Amit,

i don't think that this would work for me. I need to compare the value for the specific date with the value before and calculate the difference.

 

Or myabe i did no understand the example

amitchandak's avatar
amitchandak
Super User
4 years ago

DiegoSRNA , assume you need a column to show the value on last date and take a diff

 

new column =

var _max = maxx(filter(Table, [Date]< earlier([DAte]) , [Date])

return

[value] - maxx(filter(Table, [Date]=_max) , [value])