Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Calculated column using multiple conditions

Hi   I have columns in a table like Request type and Leave taken days but the request type as work from home should not to be consider as a leave. The maternity leave should not consider as a leav...
Need Help
  • themistoklis's avatar
    themistoklis
    7 years ago

    Anonymous

     

    It seems that your days columns are datatype text.

     

    Change them to number

     

  • v-chuncz-msft's avatar
    v-chuncz-msft
    7 years ago

    Anonymous,

     

    You may use DAX below.

    Column =
SWITCH (
    'LEAVE DETAILS'[Request type],
    "Work FromHome", 0,
    "Maternity leave", MAX ( 0, 'LEAVE DETAILS'[Leave taken days] - 150 ),
    "Marriage leave", MAX ( 0, 'LEAVE DETAILS'[Leave taken days] - 5 )
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
7 years ago

Anonymous,

 

You may use DAX below.

Column =
SWITCH (
    'LEAVE DETAILS'[Request type],
    "Work FromHome", 0,
    "Maternity leave", MAX ( 0, 'LEAVE DETAILS'[Leave taken days] - 150 ),
    "Marriage leave", MAX ( 0, 'LEAVE DETAILS'[Leave taken days] - 5 )
)