Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I have the field product ID and I want to count if date 1 = date 2.
Product ID Date 1 Date 2
22568 21/02/2017 21/02/2017
26987 22/02/2017 23/02/2017
69854 23/02/2017 23/02/2017
Thank you
It depends on your data model. If all fields are in a single table, try like:
Count( Distinct {<[Product ID]={"=Date1=Date2"}>}[Product ID] )