Forum Discussion
Solved
Identifying resamples
I have a large table of laboratory samples. I am interested in building a column that shows whether a given sample point was resampled on that day. Conceptually, this is simple--if the same sample...
HI,
Can you try below formula 🙂
Resampled =
IF (
CALCULATE (
COUNTA ( check[Sampling Point] ),
ALLEXCEPT ( check, check[Sampled Date], check[Sampling Point ] )
) > 1,
TRUE (),
FALSE ()
)Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂Regards,
N V Durga Prasad
nvprasad
Solution Sage
Solution SageHI,
Can you try below formula 🙂
Resampled =
IF (
CALCULATE (
COUNTA ( check[Sampling Point] ),
ALLEXCEPT ( check, check[Sampled Date], check[Sampling Point ] )
) > 1,
TRUE (),
FALSE ()
)
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad