Forum Discussion

Joachimnicho's avatar
Joachimnicho
Frequent Visitor
8 years ago
Solved

Return a value based upon the latest date

Hi,    I need help with an issue.    I have a column with a project number [Projektnr], which has a delivery type [Leverancetype]. The [Projektnr] column has some duplicates. Whenever there is a...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Joachimnicho,

     

    You may refer to the following DAX that creates a new table.

    Table =
FILTER (
    Table1,
    RANKX (
        CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[Projektnr] ) ),
        Table1[Datostempel],
        ,
        DESC,
        DENSE
    )
        <= 1
)
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Joachimnicho,

 

You may refer to the following DAX that creates a new table.

Table =
FILTER (
    Table1,
    RANKX (
        CALCULATETABLE ( Table1, ALLEXCEPT ( Table1, Table1[Projektnr] ) ),
        Table1[Datostempel],
        ,
        DESC,
        DENSE
    )
        <= 1
)