Create a Calculated Table that only brings Last Date rows.

[mpgaon]

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]))

[az38 · Accepted solution]

Hi @mpgaon 

try this

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