manideep547Helper III6 years agosql to dax select distinctcount(*) from table where Date<' date' andDate>' date 'and customers id in (select Customer Id from table where date<'date' and date>' date ')
MariuszCommunity Champion6 years agoHi manideep547 INTERSECT will work as well. Best Regards,MariuszPlease feel free to connect with me. LinkedIn
Related contentConvert SQL into DAXDAX equivalent of SQL's NOT IN?DAX equivalent of SQL LIKEConverting SQL into DAX...SQL TO DAX
