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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Latest Measurements in One Table

Hello,

 

I am trying to return the latest measurement by parameter (and its corresponding date) for each unique Well Number in ONE table visualization. The Unique ID is actually an Oil well number and the parameters are different types of measurements that are reported on different dates. See example of desired output below. 

Unique Well NumberLast Oil Rate (bopd)Last Oil Rate DateLast Pressure (psi)Last Pressure Date 
1508/15/20205008/20/2020
2308/17/20208008/16/2020
3208/10/20201008/11/2020

 

 

I have only been able to create these as two separate table visualizations with the same unique well numbers being repeated on the same canvas. There is an ambuiguity problem with the relationships in the schema when joining the Pressure & Oil Rate tables to the Date and Unique Well number tables also so I'm not sure what to do there as well.

 

I have created a "IsLatest" calculated column in the Oil Rate & Pressure tables and used that to filter to the latest dates for each table.

Can anyone assist? See link below containing zip file for created power bi file and excel data source

 

https://drive.google.com/file/d/1ux8Yt7p9b9G_JVBttZK_n8SfjV2TsmfT/view?usp=sharing

 

Thanks in advance

1 REPLY 1
lbendlin
Super User
Super User

Have you considered LASTNONBLANK() or LASTNONBLANKVALUE() ?

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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