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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi All,

 

Thanks PrasanthKumar for this.

 

I've done something similar but now I need to build on it, replacing the values with parameters, so the client can edit the thresholds for each band. So based on the example below, my script looks like this:

 

CustomColumn = 

(if ([Age of Incidents]>=#"Parameter1" and [Age of Incidents]<#"Parameter2") then "0-30" else  if ([Age of Incidents]>=#"Parameter3" and [Age of Incidents]<#"Parameter4") then "30-60" else "")

 

... and so on. Error reads:  The following syntax error occurred during parsing: Invalid token line 2, offset 26, #.

 

Any help would be gratefully received.

 

Thanks,

Kevin