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

PrasanthKumar's avatar
PrasanthKumar
Frequent Visitor
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

prakash11440278's avatar
prakash11440278
Post Prodigy
8 years ago

Hi PrasanthKumar,

 

Its Working. Thanks for your help....:manhappy:

  • PrasanthKumar's avatar
    PrasanthKumar
    Frequent Visitor
    8 years ago
    Cool..always welcome..!!! Have a good day..!!