title: DAX Error: Expressions that yield variant data-type cannot be used to define calculated columns
body: <p>Im back again guys, with a new issue... I dont understand this power bi, its so easy on excel haha. </p>
  
  <p>Im getting the following error: </p>
  
  <blockquote>
    <p>Expressions that yield variant data-type cannot be used to define
    calculated columns.</p>
  </blockquote>
  
  <pre><code>SLASERV1 = IF('DIARIO Backlog de incidencias'[Prioridad];"";
  IF(OR('DIARIO Backlog de incidencias'[Prioridad]="Crítica";'DIARIO Backlog de incidencias'[Prioridad]="Máxima");4-('DIARIO Backlog de incidencias'[Horas totales sin Pending]*24);
  IF(OR('DIARIO Backlog de incidencias'[Prioridad]="Alta";'DIARIO Backlog de incidencias'[Prioridad]="High");8-('DIARIO Backlog de incidencias'[Horas totales sin Pending]*24);
  IF(OR('DIARIO Backlog de incidencias'[Prioridad]="Media";'DIARIO Backlog de incidencias'[Prioridad]="Medium");24-('DIARIO Backlog de incidencias'[Horas totales sin Pending]*24);
  IF(OR('DIARIO Backlog de incidencias'[Prioridad]="Baja";'DIARIO Backlog de incidencias'[Prioridad]="Low");48-('DIARIO Backlog de incidencias'[Horas totales sin Pending]*24)
  )))))
  </code></pre>
  
  <p><strong>POWER BI COLUMNS</strong></p>
  
  <p><a href="https://i.stack.imgur.com/5PzbH.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5PzbH.png" alt="enter image description here"></a>
  <a href="https://i.stack.imgur.com/dyhBR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/dyhBR.png" alt="enter image description here"></a></p>
  
  <p><strong>How its done in excel (Column P is the result I need):</strong> </p>
  
  <p><a href="https://i.stack.imgur.com/AbAco.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/AbAco.png" alt="enter image description here"></a></p>
  
  <pre><code>=IF(K3&lt;&gt;"";IF(E3="";"";
       IF(OR(E3="Crítica";E3="Máxima";E3="Urgent");4-(Q3*24);
          IF(OR(E3="Alta";E3="High");8-(Q3*24);
             IF(OR(E3="Media";E3="Medium");24-(Q3*24);
                IF(OR(E3="Baja";E3="Low");48-(Q3*24)
   ))))))
  </code></pre>
  
  <p>What am I doing wrong?</p>