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:

DateValue
04/02/202220
05/02/202221
06/02/202225

 

What I need is to calculate the evolution of that record, comparing the value of the specific record with the value of that record 6 (or n) days ago.
For example:
Today (04-02-2022), I have 20 sales for this date, but when I checked on 02-02-2022 how the sales were for 04-02-2022, I had 15 sales. Therefore the evolution are +5.

 

Anyone did something like this before ?

Thanks in advance

  • 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.

4 Replies

  • 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.

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