Forum Discussion

mpgaon's avatar
mpgaon
Frequent Visitor
6 years ago
Solved

Create a Calculated Table that only brings Last Date rows.

Hello, I need to build a Calculated Table that feeds from a Table within my data model but I need it to only show rows from the last Snapshot date.

 

My Table fields are: Snapshot Date, seller, customer, sales stage.

 

I only want the Calculated Table to show all the columns and rows from the last Snapshot date.

 

This is the function I've been trying, it only brings the column names but no rows:

Snapshot date = CALCULATETABLE(Trackers, LASTDATE(Trackers[Snapshot Date].[Date]))

 

  • Hi mpgaon 

     

    try this

    Snapshot date = CALCULATETABLE(Trackers; LASTDATE(Trackers[Snapshot Date]))

1 Reply

  • az38's avatar
    az38
    Community Champion

    Hi mpgaon 

     

    try this

    Snapshot date = CALCULATETABLE(Trackers; LASTDATE(Trackers[Snapshot Date]))