topic Re: Dax HELP in DAX Commands and Tips

Dax HELP

Anonymous — Tue, 29 Nov 2022 17:45:49 GMT

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".

Re: Dax HELP

tamerj1 — Tue, 29 Nov 2022 18:22:46 GMT

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" )

Re: Dax HELP

Anonymous — Tue, 29 Nov 2022 18:26:07 GMT

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