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.
I have tried to search in google and in this community to find a solution for this, unfortunately no luck.
I have two tables as per the attachements in links below:
I would like to show only the latest date with its corresponded row for each well number.
Solved! Go to Solution.
After Grouping as you showed, expand the "Rest of Column".
add a custom column where you type
[Rig Spud] = [Max Date]
now filter only True from this column then delete unnecessary columns
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@2019
Can you explain more on the expected results?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Yes of course,
The desired result would be a table with the latest dates of Rig spud for each well number.
Let’s take Ru-160 well number as example, in SPUD table/query as you can see there are 4 rows for this well, the desired result would be one row which contain the latest Rig spud date, in this example it’s the 3rd row which have the date 10/27/2020 as shown in below image, and so on for the rest of the well numbers in tables.
I was trying to use the group by with Max () function operation but it did not fully work, it was pulling the latest date but the wrong Rig number, that is why I was hoping to find a way where well number get checked row by row and find the latest Rig spud date, then power bi pull that particular row alongside with corresponded rows (Rig number and station)
After Grouping as you showed, expand the "Rest of Column".
add a custom column where you type
[Rig Spud] = [Max Date]
now filter only True from this column then delete unnecessary columns
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@2019
Click on the filter of the "Rig Spud" column and choose "Is Latest" under the date filter as shown in the example below.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
You can Sort Descending [Rig Spud], then Keep Top Rows, only first.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.