Forum Discussion
Filtering ID & date compared within two date columns and many lines for this ID
Hi, LithanaM
If you are trying to eliminate the (FinStage-RecMin>0) rows, you can try the following method.
Original table:
Table:
Table 2 =
Var table1=SUMMARIZE('Table','Table'[Date],'Table'[FinStage-RecMin],'Table'[Stage])
Var table2=FILTER(table1,[FinStage-RecMin]<=0)
return
table2
Is this the result you expect?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Bonjour,
Unfortunately, I can't just eliminate the >0 lines, because some of them are unique and have to be kept.
I actually work with historical data that were cumulated and where duplicates were eliminated, but it was not always the most recent entries that were kept, hence the problem I am having now....
I didn't have an example in this table, but I can have a finstage-recmin>0 but that does not exist in other instances and need to be kept.
Nathalie