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

[Luzadriana255]

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

[Anonymous]

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!

[FreemanZ · Accepted solution]

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:

[Luzadriana255]

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!

[FreemanZ]

Aha, then change MINX to MAXX, like this:

DateReception =

VAR _request = TableName[Request]

RETURN

MAXX(

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

    TableName[DateComplete]

)

[Luzadriana255]

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