topic Re: Controlling the date that a particular request with different steps enters a system in DAX Commands and Tips

Controlling the date that a particular request with different steps enters a system

Luzadriana255 — Tue, 13 Dec 2022 12:55:49 GMT

Hello!

I have a 4 step process for different requests (a and b in the table). The process should be completed in the order from 1 to 4. Addittionally, I have specific dates for every step. I need a new Column (Reception in the system) that provides me the date of the step 1 for all the steps of a particular request. Could you please suggest me a Dax formula that can be helpful in this case? Thank you so much!

Request	Step	Date of completion	Reception in the system
a	1	20.03.2021	20.03.2021
a	2	28.03.2021	20.03.2021
a	3	06.04.2021	20.03.2021
a	4	15.04.2021	20.03.2021
b	1	23.04.2022	23.04.2022
b	2	04.05.2022	23.04.2022
b	3	20.06.2022	23.04.2022
b	4	28.06.2022	23.04.2022

Re: Controlling the date that a particular request with different steps enters a system

Luzadriana255 — Tue, 13 Dec 2022 13:29:33 GMT

amitchandak could you please help me with an advice on how to solve this. Thank you!

Re: Controlling the date that a particular request with different steps enters a system

FreemanZ — Tue, 13 Dec 2022 13:31:26 GMT

hi Luzadriana255

try to create a column with this:

DateReception =

VAR _request = TableName[Request]

RETURN

MINX(

FILTER(TableName, TableName[Request] = _request ),

TableName[DateComplete]

)

I tried and it worked like this:

Re: Controlling the date that a particular request with different steps enters a system

Anonymous — Tue, 13 Dec 2022 13:43:24 GMT

Hi Luzadriana255 ,

Please find below solution.

Column = CALCULATE(MIN(Sheet1[Date of completion]),ALLEXCEPT(Sheet1,Sheet1[Request]))

Best Regards,
Shreya

Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!

Re: Controlling the date that a particular request with different steps enters a system

Luzadriana255 — Tue, 13 Dec 2022 13:46:56 GMT

Thank you for your reply, I have the problem that some dates have a default value of 01.01.2000, when they were empty. That means that they will be taken as the minx. Do you have an idea on how create a filter where dates with 01.01.2000 are not considered? or just making sure that the rang is 1, since also some rangs are empty. Thank you!

Re: Controlling the date that a particular request with different steps enters a system

FreemanZ — Tue, 13 Dec 2022 14:08:28 GMT

Aha, then change MINX to MAXX, like this:

DateReception =

VAR _request = TableName[Request]

RETURN

MAXX(

FILTER(TableName, TableName[Request] = _request ),

TableName[DateComplete]

)