DAX code for Collateral Due

[Anonymous]

Hi All,

i am trying to write dax code which help me setup conditional formatting for my collateral due column. I want to identify Collateral Due dates(Column1) which are past the current date and have no callateral received date(column2) filled in the collateral rec date column. 

currently im trying to add an AND to this 

(if(DATEDIFF(vALL_ORDER_DETAILS_ENH_V2[Collateral_Due].[Date],TODAY(),DAY)<0,"Current", if(DATEDIFF(vALL_ORDER_DETAILS_ENH_V2[Collateral_Due].[Date],TODAY(),DAY)>=0,"Past Due"))) && if((vALL_ORDER_DETAILS_ENH_V2[Collateral_Rec].[Date] <> BLANK()) 

however its not working. any help would be great

[amitchandak]

@Anonymous , Try like

if(vALL_ORDER_DETAILS_ENH_V2[Collateral_Rec] <> BLANK()
Switch(true(),
DATEDIFF(vALL_ORDER_DETAILS_ENH_V2[Collateral_Due].[Date],TODAY(),DAY)<0,"Current" ,
DATEDIFF(vALL_ORDER_DETAILS_ENH_V2[Collateral_Due].[Date],TODAY(),DAY)>=0,"Past Due"
) , blank())