Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Frequent Visitor

Table visual: only show data with most recent date

Hello community,

I have a table with data from various download dates since I need to show the development during the month. This is working fine.

I need an addiditonal table visual now, based on the same data, where only the most recent records is shown. 
Here an example:
Extract from data in table WIP:

Download DateReporting PeriodOrderTypeProductCompanySystemStatusObjectOrderTextInstallationLast cost agingPCA_WIPCustomerNameOrderStatusCoordinator
31 Dec 202131 Dec 2021ZS03AxyNot TECO11149571abcdef111.589example LtdNoBillSam
31 Jan 202231 Jan 2022ZS03AxyNot TECO11149571abcdef3102.921example LtdNoBillSam
28 Feb 202228 Feb 2022ZS03AxyNot TECO11149571abcdef12147.044example LtdNoBillSam
31 Jul 202231 Jul 2022ZS03AxyNot TECO11149571abcdef2099.999example LtdNoBillSam
31 Aug 202231 Aug 2022ZS03AxyNot TECO11149571abcdef13101.120example LtdNoBillSam
30 Sep 202230 Sep 2022ZS03AxyNot TECO11149571abcdef9101.164example LtdNoBillSam
09 Nov 202231 Oct 2022ZS03AxyNot TECO11149571abcdef40103.923example LtdNoBillSam
21 Nov 202230 Nov 2022ZS03AxyNot TECO11149571abcdef5103.989example LtdNoBillSam
09 Nov 202230 Nov 2022ZS03AxyNot TECO11149571abcdef48103.923example LtdNoBillSam

User uses slicer on "Reporting Period", e.g. Nov 2022 and the desired output should be as below. Meaning only Reporting Period Nov 2022 and the most recent Download Date. 

Download DateReporting PeriodOrderTypeCompanySystemStatusObjectInstallationLast cost agingPCA_WIPCustomerNameCoordinator
21 Nov 202230 Nov 2022ZS03xyNot TECO11149571def5103.989example LtdSam

Can somebody please help me how to get there? Thank you!

Frequent Visitor

@amitchandak thanks for your quick reply. I understand the logic for getting most recent data into a measure, but I have no idea how to show this in a table visual. Would it be possible for you to elaborate on this, please?


Super User
Super User

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors