Calculated Column with multiple conditions

Question

i have a table with following columns.&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Leave Details&nbsp;EmployeeName&nbsp; &nbsp; &nbsp; Leave taken days&nbsp; &nbsp; &nbsp;Leave Type&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Start Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;End Date&nbsp; &nbsp; &nbsp; Month diff&nbsp; &nbsp; &nbsp; Created colum&nbsp;&nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Work from home&nbsp; &nbsp; &nbsp; 24/12/2018&nbsp; &nbsp; &nbsp; &nbsp; 29/12/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 120&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Vacation Leave&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/06/2018&nbsp; &nbsp; &nbsp; &nbsp; 31/122018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp;C&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Marraige leave&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 01/06/2018&nbsp; &nbsp; &nbsp; &nbsp;10/06/2018&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp;work from home should not consider as a leave, return created column as 0marraige leave should not consider as a leave if leave taken days &lt;5, want remaining days if leave taken days &gt;5 in a created column.vacation leave should not consider as a leave if month diffe &lt;=6, return created column as 0.&nbsp;i tried the following dax&nbsp; query:&nbsp;Created Column =SWITCH(TRUE(),'Leave Details'[Request type] = "Work From Home" &amp;&amp; 'Leave Details'[Leave taken days] &gt;0,0,'Leave Details'[Request type] = "Vacation Leave" &amp;&amp; 'Leave Details'[Month diff]=6,'Leave Details'[Month diff]= -6,'Leave Details'[Request type] = "Marriage" &amp;&amp; 'Leave Details'[Leave taken days]&gt;=5,'Leave Details'[Leave taken days] - 5,'Leave Details'[Request type] = "Vacation Leave" &amp;&amp; 'Leave Details'[Month diff]&lt;6,0,'Leave Details'[Request type] = "Marriage" &amp;&amp; 'Leave Details'[Leave taken days]&lt;5,0,'Leave Details'[Leave taken days])&nbsp;error Occurs :&nbsp;&nbsp;Expressions that yield variant data-type cannot be used to define calculated columns.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

v-chuncz-msft · Accepted Answer

Anonymous,
&nbsp;
You may remove the equal sign (=) in expression below.
'Leave Details'[Month diff]= -6,

Forum Discussion

Calculated Column with multiple conditions

2 Replies

Related content

Multiple conditions Index

Conditional formatting using multiple calculation groups

Multiple Donut charts with conditions

Conditional Column with Multiple Conditions

Switch Calculation with Multiple conditions