Dax HELP

[Anonymous]

Hello World,

I have this new column Days past dues (Days Past Dues = DATEDIFF(Sheet1[TransactionDate       ],Sheet1[PaymentDate   ],DAY). Days past dues gives me the days differences between transaction date and payment date. 

I have lots of negative days past dues which means the payment was done before the transaction date. 

Now, 

I want to create a column using some logical functions where the negative days (which means payment made earlier than the transaction date) means "Early Payment". And the one with postive days means "Late Payment". And the past due days which is 0 means"At time Payment".

 

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

Payment Condition =
SWITCH (
    TRUE (),
    Sheet1[Days Past Dues] < 0, "Early Payment",
    Sheet1[Days Past Dues] > 0, "Late Payment",
    "At time Payment"
)

[Anonymous]

@tamerj1 Sir, You're genius. It worked. Thank you Sir