DAX Evolution Measure

[DiegoSRNA]

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/2022	25

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 · Accepted solution]

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.

[amitchandak]

@DiegoSRNA , are planning to select 2 dates in the slicer and then filter

Then refer

How to use two Date/Period slicers

https://youtu.be/WSeZr_-MiTg

OR you want a new column, diff from the last date 

Also check

Day Intelligence - Last day, last non continous day
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[DiegoSRNA]

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]

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