Forum Discussion

manideep547's avatar
manideep547
Icon for Helper III rankHelper III
6 years ago

sql 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 ')
Need Help
manideep547's avatar
manideep547
Icon for Helper III rankHelper III
6 years ago

Correct me if I'm wrong 

I used INTERSECT Dax function with countRows

Mariusz 



Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
6 years ago

Hi manideep547 

 

INTERSECT will work as well.

 

Best Regards,
Mariusz

Please feel free to connect with me.
LinkedIn