Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX equivalent to %LIKE% in sql - to count IDs

Hello,   I am trying to do a simple count in Power BI using dax.    In sql, I would simply use this function to pull my data:   Select count (distinct Client_ID) Client_ID from table Where st...
Need Help
  • hnguy71's avatar
    hnguy71
    4 years ago

    Hi Anonymous ,

     

    You may be trying to compare a date field against a string value. This should work:

    CALCULATE(
    COUNT(clients[CLIENT_ID]), 
        SEARCH("UNIVERSITY", clients[School], 1, 0) > 0,
        clients[start_date] >= DATE(2021, 03, 16)
)
hnguy71's avatar
hnguy71
Icon for Super User rankSuper User
4 years ago

Hi Anonymous ,

 

You may be trying to compare a date field against a string value. This should work:

CALCULATE(
    COUNT(clients[CLIENT_ID]), 
        SEARCH("UNIVERSITY", clients[School], 1, 0) > 0,
        clients[start_date] >= DATE(2021, 03, 16)
)
Anonymous's avatar
Anonymous
Not applicable
4 years ago

it worked! thank you so much 🙂