Multiple IFs

Question

Hi all&nbsp;I am trying to workout if something is within timeline, but i need it to check if a field has a date first then if so work out X if not check this field isnt blank and work out Y&nbsp;this is the Dax i am working with, i manage to get it to do one half but then it doesnt seem to do the second field blank check:&nbsp;Test PPA = IF(ISBLANK('DCAPPL Import'[PPACDATE]),IF('DCAPPL Import'[DATEDECISS]&gt;'DCAPPL Import'[DATE8WEEK],"Exceeds","Within"),&nbsp;IF(ISBLANK('DCAPPL Import'[DATEDECISS]),BLANK(),if('DCAPPL Import'[DATEDECISS]&gt;'DCAPPL Import'[DATE8WEEK],"Exceeds", "Within")))&nbsp;any help or suggestion would be appreciated.&nbsp;&nbsp;

tahreem24 · Accepted Answer

EloiseJane&nbsp;Try out with Switch:
Test PPA =SWITCH(TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATEDECISS&gt;DATE8WEEK,"Exceeds",&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATEDECISS=BLANK(),BLANK(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; DATEDECISS&gt;DATE8WEEK,"Exceeds", "Within")
&nbsp;

Forum Discussion

Multiple IFs

2 Replies

Related content

IF, Multiple

Multiple If

PQ Multiple IF

Multiple IF statements in DAX

IF - Multiple conditions