Forum Discussion

MORDax's avatar
MORDax
Frequent Visitor
4 years ago
Solved

Max Date joined to itself

I basically have a table that has a date column, I am trying to find the max date for each row and then join this table to itslef on the query Table1[date] joined with Table1[MaxDate] So that I c...
DAX
M
Maxdate
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    Hi MORDax ,

    According to your description, here's my solution.

    In Power Query, select Asset column, then click Group By tab under Transform ribbon.

    Set it like this.

    Get the result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

MORDax , You can create a new column

max date = max(Table1[date])

 

or a new measure

max date = calculate(max(Table1[date]), all(Table1))

MORDax's avatar
MORDax
Frequent Visitor
4 years ago

In the Power Query Editor? How do I then join the table to itself for the query Table1[Date] - Table1[MaxDate]