Help with a DAX statement to analyze dates

Question

I need Help writing the DAX statement equivalent&nbsp;to the if - then-else logic below&nbsp;I am attempting&nbsp;to determine a BASE DATE by analyze dates I have in columns in my table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CARGOID&nbsp; &nbsp;RECEIVEDATE&nbsp; ORDER ASSIGN&nbsp;DATE&nbsp; &nbsp; FLEET DEALER BEGIN DATE&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;BASE DATE&nbsp;1234&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/22&nbsp; &nbsp; &nbsp; &nbsp; 08/31/22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/22&nbsp; &nbsp; &nbsp;9876&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/22&nbsp; &nbsp; &nbsp; &nbsp; 09/04/22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/05/22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;09/05/22&nbsp; &nbsp; &nbsp;8888&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/22&nbsp; &nbsp; &nbsp; &nbsp; 09/04/22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/05/22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;09/05/22&nbsp; &nbsp; &nbsp;5432&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/22&nbsp; &nbsp; &nbsp; &nbsp; 09/03/22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;09/03/22&nbsp; &nbsp; &nbsp;&nbsp;1122&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 09/01/22&nbsp; &nbsp; &nbsp;&nbsp;If ORDER ASSIGN&nbsp;DATE Is Null&nbsp;&nbsp; &nbsp;then&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BASE DATE = Receive Dateelse&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; If ORDER ASSIGN&nbsp;DATE &gt; Receive Date then&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If [FLEET DEALER BEGIN DATE] Is Not Null And [FLEET DEALER BEGIN DATE &gt; ORDER ASSIGN&nbsp;DATE &nbsp;&nbsp;then&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BASE DATE =[ FLEET DEALER BEGIN DATE],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; else&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BASE DATE = ORDER ASSIGN&nbsp;DATE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; end if&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;If {FLEET DEALER BEGIN DATE] Is Not Null And [FLEET DEALER BEGIN DATE] &gt; Receive Date , then&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BASE DATE = [FLEET DEALER BEGIN DATE],&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;else&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;BASE DATE = Receive Date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; End if&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;end ifend if&nbsp;I tried the below dax code but just can get it to work&nbsp;&nbsp;Base Date&nbsp; = IF (isblank(MAX(Inventory[ORDERASSIGNMENTDATE])), --then &nbsp; &nbsp; MAX(Inventory[RECEIVEDATE]), -- else&nbsp; &nbsp; &nbsp; &nbsp;IF (not(isblank(MAX(Inventory[FLEETDELIVERYBEGINDATE]))) &amp;&amp; IF (MAX(Inventory[FLEETDELIVERYBEGINDATE]) &gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; (MAX(Inventory[ORDERASSIGNMENTDATE])), -- then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Max(Inventory[FLEETDELIVERYBEGINDATE]), &nbsp; &nbsp; &nbsp; &nbsp; --else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; MAX(Inventory[ORDERASSIGNMENTDATE])&nbsp; &nbsp; &nbsp; &nbsp; --endif&nbsp; &nbsp; &nbsp; &nbsp;)&nbsp; &nbsp; || -- not sure if this is correct use&nbsp;of the ||&nbsp;&nbsp; &nbsp; IF (not(isblank(MAX(Inventory[FLEETDELIVERYBEGINDATE]))) &amp;&amp; If (Max(Inventory[FLEETDELIVERYBEGINDATE]) &gt; (MAX(Inventory[RECEIVEDATE])), &nbsp;---then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Max(Inventory[FLEETDELIVERYBEGINDATE]), ----&nbsp; &nbsp; &nbsp; &nbsp; --else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;MAX(Inventory[RECEIVEDATE])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;)&nbsp; &nbsp; &nbsp; &nbsp; --endif&nbsp; -- endif&nbsp;&nbsp;Any assistance would be greatly appreciated&nbsp;Thank You&nbsp;

johnt75 · Answer

If I understand correcly you want to create a new column which has the max value from 3 other columns on the same table for that row. You can add a column like
Base date =
MAXX (
    {
        'Table'[Receive Date],
        'Table'[Order assign date],
        'Table'[Fleet dealer begin date]
    },
    [Value]
)

scottwill · Answer

John, Thank You for the quick&nbsp;However what I am trying to do is create a measure based on the&nbsp;LOGIC I posted.&nbsp; The Logic is from an access program I have and I am trying to recreate the BASE DATE logic&nbsp;in DAX&nbsp;.&nbsp; So I am trying to see if anyone in the&nbsp;&nbsp;DAX forum group can assist in converting the logic&nbsp;I have posed to a DAX measure statement&nbsp;&nbsp;

Forum Discussion

Help with a DAX statement to analyze dates

2 Replies

Related content

Best Practice Analyzer

Analyze in excel Date Filter

Date IF Statement

Converting Epoch Date fields within the import statement

OR Statement ?