Forum Discussion

yforti's avatar
yforti
Helper II
6 years ago
Solved

Help with calculated dates

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 ...
Need Help
Tutorial Requests
  • ryan_mayu's avatar
    ryan_mayu
    6 years ago

    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's avatar
ryan_mayu
Super User
6 years ago

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's avatar
yforti
Helper II
6 years ago

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's avatar
    ryan_mayu
    Super User
    6 years ago

    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)