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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Ashik008
Frequent Visitor

latest date column needed

Hi all,

I need help with data .

I have table with id and date data. I need a column with latest date if the id

service idcompleted date
1016/20/2024
1015/10/2023
10210/10/2023
1031/1/2023
1031/1/2024

 

i need the result 

service idcompleted datelatest complete date
1016/20/20246/20/2024
1015/10/20236/20/2024
10210/10/202310/10/2023
1031/1/20231/1/2024
1031/1/20241/1/2024

Please help me with it

1 ACCEPTED SOLUTION
AntrikshSharma
Community Champion
Community Champion

@Ashik008 

Latest Completed Date = 
CALCULATE ( 
    MAX ( 'Table'[completed date] ),
    ALLEXCEPT ( 'Table', 'Table'[service id] )
)

 

AntrikshSharma_0-1718904379115.png

 

View solution in original post

4 REPLIES 4
AntrikshSharma
Community Champion
Community Champion

@Ashik008 

Latest Completed Date = 
CALCULATE ( 
    MAX ( 'Table'[completed date] ),
    ALLEXCEPT ( 'Table', 'Table'[service id] )
)

 

AntrikshSharma_0-1718904379115.png

 

rajendraongole1
Community Champion
Community Champion

Hi @Ashik008 - you can use max function on completed date and filter based on ID with current id.

 

Calculated columns as below:

LatestCompleteDate =
VAR CurrentServiceID = ServiceData[service id]
RETURN
CALCULATE(
MAX(ServiceData[completed date]),
FILTER(
ServiceData,
ServiceData[service id] = CurrentServiceID
)
)

 

rajendraongole1_0-1718895876143.png

 

Report view:

rajendraongole1_1-1718895963947.png

 

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

@rajendraongole1 hi sir ,can you share the pbix file for it. formula not working for ,me

ajohnso2
Resolver II
Resolver II

Something like this should work:

Latest Completion Date =
VAR _ServiceID = SELECTEDVALUE('YourTable'[Service ID])
VAR _DateCompleted =

FILTER(
    ADDCOLUMNS(
        CALCULATETABLE(
            ALL('YourTable'[Service ID], 'YourTable'[Date Completed])
        ),
        "@MaxCompletedDate", 'YourTable'[Date Completed]
    ),
    'YourTable'[Service ID] = _ServiceID
)

RETURN
MAXX(_DateCompleted, [@MaxCompletedDate])

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.