DAX lookupvalue whit max and min

Simon_Br — Thu, 27 Jul 2023 08:35:32 GMT

Hello,

I'm a newbi whit Power BI and have a Problem whit the lookupvalue and max and min.

In a tabele i have all Data, but i will from every DutyID only the min RevisedStart and the min RevisedEnd. See the Example below.

But i don't know, we i do this.

Can anyone help me with this?

ID	DutyNo	RevisedStart	RevisedEnd	DutyID
ec0dfbbc-5b21-4041-be4c-8384ed19ba3e	Test Simon 01	18.07.2023 08:34	18.07.2023 08:39	7e02c0db-ca2f-45fb-a0a4-72d775542d57
af572160-554c-41e1-9f22-8f27c8592809	Test Simon 01	18.07.2023 08:39	18.07.2023 08:39	7e02c0db-ca2f-45fb-a0a4-72d775542d57
3ff15d8d-cc58-4502-83f7-d91e142a35a0	Test Simon 01	18.07.2023 08:59	18.07.2023 08:59	7e02c0db-ca2f-45fb-a0a4-72d775542d57
8d633dd8-f2da-44a7-8731-650a35c7c7d0	Test Simon 01	18.07.2023 09:29	18.07.2023 09:29	7e02c0db-ca2f-45fb-a0a4-72d775542d57
9010d71f-8728-4f64-b6e3-fbd121da3ae2	Test Simon 01	18.07.2023 12:16	18.07.2023 12:21	7e02c0db-ca2f-45fb-a0a4-72d775542d57
65925214-ccd0-419a-989e-b9ec36c2cd04	Test Simon 02	18.07.2023 12:59	18.07.2023 13:27	4af60dcf-2c1d-4610-957c-309d37631d27
689b4dbf-11f6-4e01-a193-b3934a5b4c2d	Test Simon 01	18.07.2023 13:01	18.07.2023 13:21	7e02c0db-ca2f-45fb-a0a4-72d775542d57
a3b62c4c-db6a-41de-a9bc-ca21ecc04d8c	Test Simon 02	18.07.2023 13:27	18.07.2023 13:27	4af60dcf-2c1d-4610-957c-309d37631d27
b2d112b1-c23b-4b4f-a6b5-ab58de2fdd59	Test Simon 01	18.07.2023 13:34	18.07.2023 13:36	7e02c0db-ca2f-45fb-a0a4-72d775542d57
7079137a-61a8-4e33-b26c-2cbf947a2a4d	Test Simon 01	18.07.2023 13:36	18.07.2023 14:11	7e02c0db-ca2f-45fb-a0a4-72d775542d57
19ef8cef-df0f-4fd2-aa60-9ac8de94ecae	Test Simon 01	18.07.2023 16:46	18.07.2023 16:56	7e02c0db-ca2f-45fb-a0a4-72d775542d57
4f2bf56a-2df2-4ee5-b0d6-b346cdbcbf0c	Test Simon 01	18.07.2023 16:56	18.07.2023 16:56	7e02c0db-ca2f-45fb-a0a4-72d775542d57
01c1f29c-e2ca-4f20-95b2-29404bf64447	Test Simon 02	18.07.2023 17:00	18.07.2023 17:00	4af60dcf-2c1d-4610-957c-309d37631d27
f7cbd181-02b0-43e5-958e-7c97b1e975ea	Test Simon 02	18.07.2023 17:35	18.07.2023 17:35	4af60dcf-2c1d-4610-957c-309d37631d27
1cc97e5b-7785-4403-8d40-076df760f5a5	Test Simon 02	18.07.2023 17:41	18.07.2023 17:43	4af60dcf-2c1d-4610-957c-309d37631d27
067e1ec9-cb7b-4f87-82b8-65774371edf7	Test Simon 01	18.07.2023 17:45	18.07.2023 17:45	7e02c0db-ca2f-45fb-a0a4-72d775542d57
8e81a569-2bc5-4cba-8a17-b8ea6b6fcc74	Test Simon 02	18.07.2023 17:46	18.07.2023 17:49	4af60dcf-2c1d-4610-957c-309d37631d27
8c5136f1-47bf-4c36-b4bf-5482e2715435	Test Simon 02	18.07.2023 17:49	18.07.2023 17:51	4af60dcf-2c1d-4610-957c-309d37631d27
aa3ec9f3-2e7a-40fe-b91c-fb4bf07e1717	Test Simon 01	18.07.2023 18:00	18.07.2023 18:00	7e02c0db-ca2f-45fb-a0a4-72d775542d57
85e409bf-59c4-4a6a-9244-7841df3ed13d	Test Simon 01	18.07.2023 18:06	18.07.2023 18:16	7e02c0db-ca2f-45fb-a0a4-72d775542d57
f3796308-6658-45aa-8454-64a16d53dc59	Test Simon 02	18.07.2023 18:30	18.07.2023 19:00	4af60dcf-2c1d-4610-957c-309d37631d27
c8f31621-458b-42a4-93e5-dca302028153	Test Simon 02	18.07.2023 19:41	18.07.2023 19:46	4af60dcf-2c1d-4610-957c-309d37631d27
67565e8f-c1e5-4937-80bf-0e4659f222f8	Test Simon 02	18.07.2023 19:49	18.07.2023 22:42	4af60dcf-2c1d-4610-957c-309d37631d27
b6d462f0-6e66-448e-a269-b804c2fbc446	Test Simon 02	18.07.2023 22:42	18.07.2023 22:52	4af60dcf-2c1d-4610-957c-309d37631d27
ca2f5cfd-f0e5-4d04-a7d5-c635bf6a605a	Test Simon 02	18.07.2023 22:52	18.07.2023 23:20	4af60dcf-2c1d-4610-957c-309d37631d27



Solution in a new tab:
7e02c0db-ca2f-45fb-a0a4-72d775542d57	Test Simon 01	18.07.2023 08:34	18.07.2023 18:16
4af60dcf-2c1d-4610-957c-309d37631d27	Test Simon 02	18.07.2023 12:59	18.07.2023 23:20

Simon

Re: DAX lookupvalue whit max and min

Anonymous — Mon, 31 Jul 2023 03:43:45 GMT

Hi Simon_Br ,

As far as I know, you can try EARLIEST or LATEST function in table visual to get min or max RevisedStart and the RevisedEnd.

Or you can try code as below to create measure or calculated column to get result.

min Revised Start = CALCULATE(MIN('Table'[RevisedStart]),ALLEXCEPT('Table','Table'[DutyID]))

Max Revised End = CALCULATE(MIN('Table'[RevisedEnd]),ALLEXCEPT('Table','Table'[DutyID]))

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

topic Re: DAX lookupvalue whit max and min in DAX Commands and Tips

DAX lookupvalue whit max and min

Re: DAX lookupvalue whit max and min