Forum Discussion

prakash11440278's avatar
prakash11440278
Post Prodigy
8 years ago
Solved

Multiple IF Conditions in Custom Column

Hi All,   I am calculating Age Category DAX formula based on the Incident logged. But i want below DAX formula to be replicated in Custom Column in Query Editor for Sorting purpose. Please provide ...
Need Help
  • PrasanthKumar's avatar
    PrasanthKumar
    8 years ago

    Hi,

     

    Can you please try this custom column query: 

    (if ([Age of Incidents]>=0 and [Age of Incidents]<30) then "0-30" else  if ([Age of Incidents]>=30 and [Age of Incidents]<60) then "30-60" else if ([Age of Incidents]>=60 and [Age of Incidents]<90) then "60-90" else if ([Age of Incidents]>=90 and [Age of Incidents]<180) then "90-180" else if ([Age of Incidents]>=180 and [Age of Incidents]<90) then "180+" else "")

     

    Thanks,

    Prasanth.C

    +91 9043194307

Anonymous's avatar
Anonymous
Not applicable
7 years ago

IF the value in Col A and Col B is equal to 0 then it should give me 1 else 0 along with including this third condition as if A and B both are equal to 0 it should give me "NA". This is not working for me while adding a formula in new column in power BI. How do i resolve it?

 

This is the condition as per Excel formula: =IF(AND(E5=0,F5<>0),1,IF(AND(E5=0,F5=0),"na",0)). However; this is not working in Power BI.