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.

Anonymous's avatar
Anonymous
Not applicable
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.