Forum Discussion
Solved
Filter on Self Join
Please I have a scenario, where I get snapshot of a db every day (merge the files into one table).There are different questions that could be asked on different files, although we are particular abou...
I think you just need one more filter step.
ChangedDate = VAR Latestopp = [...] VAR prevopp = [...] VAR IJOIN = NATURALINNERJOIN ( Latestopp, prevopp ) RETURN FILTER ( IJOIN, [Current Date] <> [Previous Date] )
Thank you for the answer