Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Last Date Modified (Column vs Column)

Hello,   I have a data set with items and their contract price. These contracts are modified by either the branch or the corporate headquarters. These are each in different columns. I would like to...
  • th3h0bb5's avatar
    th3h0bb5
    9 years ago

    You should be able to do this with a nested IF statement to see which column has the older date. The first two IF statements check to see if the column is blank. If they are, it returns the other column. The final IF statement compares the two columns if they're not blank and gives you the older one.

     

    lastMod = IF(ISBLANK([Last Modified - Branch]),[Last Modified - Corporate], IF(ISBLANK(Table1[Last Modified - Corporate]),[Last Modified - Branch], IF([Last Modified - Branch]<=[Last Modified - Corporate],[Last Modified - Branch], [Last Modified - Corporate])))

th3h0bb5's avatar
th3h0bb5
Resolver II
9 years ago

You should be able to do this with a nested IF statement to see which column has the older date. The first two IF statements check to see if the column is blank. If they are, it returns the other column. The final IF statement compares the two columns if they're not blank and gives you the older one.

 

lastMod = IF(ISBLANK([Last Modified - Branch]),[Last Modified - Corporate], IF(ISBLANK(Table1[Last Modified - Corporate]),[Last Modified - Branch], IF([Last Modified - Branch]<=[Last Modified - Corporate],[Last Modified - Branch], [Last Modified - Corporate])))

Anonymous's avatar
Anonymous
Not applicable
9 years ago

th3h0bb5

I had tried that and it didn't work... Turns out one of my date categories was formatted as a text. :smileymad:

 

Thanks for your help