title: Multiple IF Statements in DAX
body: <p>I currently have Column Data formulated below in Power BI which I need for it to display in one column but replacing the "1" with a Text value being:</p>
  
  <p>Orginal column formula:</p>
  
  <pre><code>Age (18-27) = IF(AND([Age]&gt;17, [Age]&lt;28),"1",BLANK())
  Age (28-35) = IF(AND([Age]&gt;27, [Age]&lt;36),"1",BLANK())
  Age (36-43) = IF(AND([Age]&gt;35, [Age]&lt;44),"1",BLANK())
  Age (44-50) = IF(AND([Age]&gt;43, [Age]&lt;51),"1",BLANK())
  Age (50+) = IF([Age]&gt;50,"1 ", BLANK())
  </code></pre>
  
  <p>Output:</p>
  
  <pre><code>Age (18-27) = IF(AND([Age]&gt;17, [Age]&lt;28),"Age (18-27)",BLANK())
  Age (28-35) = IF(AND([Age]&gt;27, [Age]&lt;36),"Age (28-35)",BLANK())
  Age (36-43) = IF(AND([Age]&gt;35, [Age]&lt;44),"Age (36-43)",BLANK())
  Age (44-50) = IF(AND([Age]&gt;43, [Age]&lt;51),"Age (44-50)",BLANK())
  Age (50+) = IF([Age]&gt;50,"Age (50+) ", BLANK())
  </code></pre>
  
  <p>I would like to have the formula display the data in one column where it is consolidating the Output formula (seen above) so I see the results in one column.</p>