create calculated column to filter first and lasttime occurence of ID

[qwertzuiop]

Hello Dear PowerBI Community

I would be very grateful, if you could help me.

As can be seen in the table, there are different transports with IDs.

I would like to check chronologically which message per transport ID is sent first and which last.

The result should be in a calculated table as in the example.

transportID	created	CheckOccurence
123	22.10.2019 01:45	FirstTime
123	23.10.2019 03:15	x
123	24.10.2019 21:45	x
456	24.10.2019 22:11	FirstTime
456	24.10.2019 23:32	LastTime
789	24.10.2019 23:50	FirstTime
789	25.10.2019 03:30	x
789	25.10.2019 05:20	LastTime
123	25.10.2019 16:30	x
123	25.10.2019 19:12	LastTime

Cheers!

qwertzuiop

[az38 · Accepted solution]

Hi @qwertzuiop 

please do not double topics.

solution is here https://community.powerbi.com/t5/Desktop/Check-first-and-lasttime-of-ID-Occurence/m-p/892088#M427646

do not hesitate to give a kudo to useful posts and mark solutions as solution

[qwertzuiop]

Hello @az38 
I'm very sorry for double the topic.

My request was very urgent and so i hoped for quick help.
You have helped me enormously with your support.
Thanks a lot once again.