Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Calculate Day Diff between 2 dates on row level

Hi there,   I hope you can help me!   I have an issue: I used the table below as an example   I am trying to calculate the day difference based on " Change Date " for each Product based on " En...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous 

     

    Please check the below code. This gives 1 day as per your need.

     

    CHANGE DATE = DATEDIFF([PHASE],MAXX(FILTER(TABLE,[PRODUCT] = EARLIER(PRODUCT) && [ENTRY] < EARLIER([ENTRY])),[PHASE] ),DAY)

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous 

 

Please check the below code. This gives 1 day as per your need.

 

CHANGE DATE = DATEDIFF([PHASE],MAXX(FILTER(TABLE,[PRODUCT] = EARLIER(PRODUCT) && [ENTRY] < EARLIER([ENTRY])),[PHASE] ),DAY)