Help with calculated dates

[yforti]

Hi guys!

I am having a calculation problem for the difference in dates between the steps of my data model.

Here's the model:

I need to calculate the difference in dates between each step, for that I made a measure that didn't work entirely. 

Measure created: 

 

 This measure works when I don't use the step in the vision:

We can see above that the calculation is done correctly between the dates.

When I use the step in the table the calculation stops happening:

Can someone help me solve this problem?

[ryan_mayu]

@yforti 

please  try this

Measure = 
var last=maxx(FILTER(all('Table'),'Table'[DT_atualizacao]<SELECTEDVALUE('Table'[DT_atualizacao])),'Table'[DT_atualizacao])
return if(ISFILTERED('Table'[DT_atualizacao]),if(ISBLANK(last),0,SELECTEDVALUE('Table'[DT_atualizacao])-MAXX(FILTER(all('Table'),'Table'[DT_atualizacao]=last),'Table'[DT_atualizacao])),CALCULATE(max('Table'[DT_atualizacao]),all('Table'))-CALCULATE(MIN('Table'[DT_atualizacao]),ALL('Table')))

[yforti]

@ryan_mayu 
Almost!

Now, the only thing that is still wrong is that we are calculating a difference in days for the start date of the process.

See below:

Since day 23/07/2019 is the first day of the process, we should not calculate the previous day. 
I think it would be zero.

[ryan_mayu]

@yforti 

Measure =
var last=maxx(FILTER(all('Table'),'Table'[DT_atualizacao]<SELECTEDVALUE('Table'[DT_atualizacao])),'Table'[DT_atualizacao])
return if(ISFILTERED('Table'[DT_atualizacao]),if(ISBLANK(last),0,SELECTEDVALUE('Table'[DT_atualizacao])-MAXX(FILTER(all('Table'),'Table'[DT_atualizacao]=last),'Table'[DT_atualizacao])),CALCULATE(max('Table'[DT_atualizacao]),all('Table'))-CALCULATE(MIN('Table'[DT_atualizacao]),ALL('Table')))

In the DAX, iI checked if it is the earliest date, if it is , then display 0. please have a try.

[yforti]

@ryan_mayu

I used your mesure, see below:

Is this because there is more data in the model? See below: (this is my full model)

[ryan_mayu · Accepted solution]

@yforti 

you can try to create a column

Column = 
VAR last=maxx(FILTER('Table','Table'[DT_atualizacao]<EARLIER('Table'[DT_atualizacao])&&'Table'[personalizar]=EARLIER('Table'[personalizar])),'Table'[DT_atualizacao])
return if(ISBLANK(last),0,'Table'[DT_atualizacao]-last)

[ryan_mayu]

@yforti 

Measure =
var last=maxx(FILTER(all('Table'),'Table'[DT_atualizacao]<SELECTEDVALUE('Table'[DT_atualizacao])),'Table'[DT_atualizacao])
return if(ISFILTERED('Table'[DT_atualizacao]),if(ISBLANK(last),0,SELECTEDVALUE('Table'[DT_atualizacao])-MAXX(FILTER(all('Table'),'Table'[DT_atualizacao]=last),'Table'[DT_atualizacao])),CALCULATE(max('Table'[DT_atualizacao]),all('Table'))-CALCULATE(MIN('Table'[DT_atualizacao]),ALL('Table')))

In the DAX, iI checked if it is the earliest date, if it is , then display 0. please have a try.