Forum Discussion

dmarkie's avatar
dmarkie
Frequent Visitor
4 years ago
Solved

MAXX Syntax and Locatin

Hi.  Newer to DAX and still learning.  I've read much and vids on Maxx but am having difficulty in achieving the desired outcome in this table creation.   I have two tables linked on the MasterID fie...
  • AilleryO's avatar
    AilleryO
    4 years ago

    No problem, sorry for not being more specific and anyway I was wrong, you should add the filter when you calulate max per MasterID, like :

    Table = 
    VAR CurrentMasterID = MAX( [MasterID] )
    VAR TempTable = FILTER (RELATEDTABLE(Detail), NOT ISBLANK('Detail'[VEHICLE ID]) && Detail[MasterID]>250 && CONTAINSSTRING(Detail[Description], "lof") )
    RETURN
    ADDCOLUMNS( TempTable , "Last Date" , CALCULATE(MAXX( 'Detail', [Date]) , MasterID = CurrentMasterID  )
     
    Let us know if it works
AilleryO's avatar
AilleryO
Icon for Memorable Member rankMemorable Member
4 years ago

Hi,

Did you try to use ADDCOLUMNS, to create the column with the MAXX([Date]) function ?

Something like :

VAR TempTable = FILTER (RELATEDTABLE(Detail), NOT ISBLANK('Detail'[VEHICLE ID]) && Detail[MasterID]>250 && CONTAINSSTRING(Detail[Description], "lof"))
RETURN
ADDCOLUMNS( TempTable , "Last Date" , MAXX( Date ) )

Let us know if it works

dmarkie's avatar
dmarkie
Frequent Visitor
4 years ago

Thank you.

 

I had not tried Adding a column so i attempted.  The error reported Too Few agruments were passed to MAXX function.  2 is min req'd

  • AilleryO's avatar
    AilleryO
    Icon for Memorable Member rankMemorable Member
    4 years ago

    My mistake, the first argument is the table and the second one the column so it should have been in my formula :

    MAXX( Detail , Date ) 

    • dmarkie's avatar
      dmarkie
      Frequent Visitor
      4 years ago

      Thanks getting close....this yeilded the new column however the values are all the same (4/6/2022) for all the records for all the MasterIDs.  

       

      Here's the DAX as i have entered;

       

      Table = VAR TempTable = FILTER (RELATEDTABLE(Detail), NOT ISBLANK('Detail'[VEHICLE ID]) && Detail[MasterID]>250 && CONTAINSSTRING(Detail[Description], "lof"))
      RETURN
      ADDCOLUMNS( TempTable , "Last Date" , MAXX( 'Detail', [Date]) )
      • AilleryO's avatar
        AilleryO
        Icon for Memorable Member rankMemorable Member
        4 years ago

        You can create one more VAR to store the MasterID.

        VAR CurrentMasterID = MAX( MasterID )

        and add a condition to the formula for table
        &&MasterID = CurrentMasterID