Forum Discussion
Solved
Fill a column based on a value in another column
Hi, I need to solve a selecting issue, didn't find something for weeks now. :smileysurprised: I have a list of items (not unique) with entries for several dates (Timestamp). Each item has a se...
Hi Jack42
I did it in 3 stages.1. Find if timestamp before deadline - Is Before Dead = IF(Table1[Timestamp] < Table1[Deadline], 1,0)
2. Find the max date -
MAXDATE = CALCULATE(MAX(Table1[Timestamp]),FILTER(Table1,Table1[Item Number]=EARLIER(Table1[Item Number])),FILTER(Table1,Table1[Is Before Dead] = 1))3. Find the goal record - Goal Record = IF(Table1[MAXDATE] = Table1[Timestamp], 1,0)Then filter by Goal Record = 1
Hi Jack42
I did it in 3 stages.
1. Find if timestamp before deadline - Is Before Dead = IF(Table1[Timestamp] < Table1[Deadline], 1,0)
2. Find the max date -
MAXDATE = CALCULATE(MAX(Table1[Timestamp]),
FILTER(Table1,Table1[Item Number]=EARLIER(Table1[Item Number])),
FILTER(Table1,Table1[Is Before Dead] = 1)
)
3. Find the goal record - Goal Record = IF(Table1[MAXDATE] = Table1[Timestamp], 1,0)
Then filter by Goal Record = 1
Dear AClerk,
brilliant, works very good. I learned a lot by that... many thanks!
I only needed to replace the kommata in the two „if“ statements with semicoli.
just in case s.o. finds this post and reuses it...
Cheers, Jack 👍🏻
