Forum Discussion

Faye1901's avatar
Faye1901
Helper I
6 years ago
Solved

Display Last Entry in List

Hi All   I have a SharePoint List (though I'm connecting via OData as the source is PWA) and I'm trying to display only the last record in that list by date in a table. I've written some DAX as fol...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    Faye1901 ,

     

    Modify your dax as below:

    Last Commentary 2 =
VAR LatestDate =
    MAXX (
        FILTER (
            'ReportCommentary',
            'ReportCommentary'[ProjectName] = MAX ( 'ReportCommentary'[ProjectName] )
        ),
        [Report Date]
    )
VAR LatestCommentary =
    MAXX (
        FILTER (
            'ReportCommentary',
            'ReportCommentary'[ProjectName] = MAX ( 'ReportCommentary'[ProjectName] )
                && [Report Date] = LatestDate
        ),
        'ReportCommentary'[Brief Status Summary]
    )
RETURN
    LatestCommentary

    Community Support Team _ Jimmy Tao

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

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Faye1901 ,

 

Modify your dax as below:

Last Commentary 2 =
VAR LatestDate =
    MAXX (
        FILTER (
            'ReportCommentary',
            'ReportCommentary'[ProjectName] = MAX ( 'ReportCommentary'[ProjectName] )
        ),
        [Report Date]
    )
VAR LatestCommentary =
    MAXX (
        FILTER (
            'ReportCommentary',
            'ReportCommentary'[ProjectName] = MAX ( 'ReportCommentary'[ProjectName] )
                && [Report Date] = LatestDate
        ),
        'ReportCommentary'[Brief Status Summary]
    )
RETURN
    LatestCommentary

Community Support Team _ Jimmy Tao

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