Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Need help with DAX to get similar function LIKE in SQL

I am getting an issue in creating a DAX function in Power BI. My Query SELECT SUM(AMOUNT) FROM TABLE1 WHERE REVENUE_TYPE NOT LIKE '%CRA'; I want to replicate this thing in Power BI using DAX. Nee...
  • Anonymous's avatar
    Anonymous
    3 years ago

    I tried this method and it worked for import method,

    src_rev = CALCULATE(SUM(AECG_VARICENT_INCENTIVE_HISTORY[SPLIT_AMOUNT]),
                  NOT(CONTAINSSTRING(AECG_VARICENT_INCENTIVE_HISTORY[REVENUE_TYPE],"CRA")))
     
    Thanks for the answers and suggestions!
Anonymous's avatar
Anonymous
Not applicable
3 years ago

I tried this method and it worked for import method,

src_rev = CALCULATE(SUM(AECG_VARICENT_INCENTIVE_HISTORY[SPLIT_AMOUNT]),
              NOT(CONTAINSSTRING(AECG_VARICENT_INCENTIVE_HISTORY[REVENUE_TYPE],"CRA")))
 
Thanks for the answers and suggestions!