Multiple if functions

Question

Hello alll,&nbsp;&nbsp;I am trying to create a slicer that filters reports by&nbsp; 90 days, past due, due soon. How do I write the conditions below in Dax&nbsp;if due date is over 90 days ="past due"If due date is between 45 to 90 days = "Due soon"If due day i equal to 90 days then = "90 days"&nbsp;Than you&nbsp;

anonymous · Answer

If(&nbsp; &nbsp; &nbsp;Due Date &gt; 90,&nbsp; &nbsp; "Past due",&nbsp; &nbsp; If(Due Date = 90,&nbsp; &nbsp; &nbsp; &nbsp;"90 days",&nbsp; &nbsp; &nbsp; &nbsp; If(Due Date = 45 &amp;&amp; Due Date &lt; 90,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Due soon",&nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ))

lbendlin · Answer

SWITCH(TRUE(),
[Due Date]&gt;90,"past due",
[Due Date]=90,"90 days",
[Due Date]&gt;44,"due soon",
"not due soon")

Forum Discussion

Multiple if functions

2 Replies

Related content

IF function with multiple conditions

DATESYTD function

MULTIPLE CARD

Select.Rows function with multiple Text.Contains functions

function behavior