Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to Solution.
try to create a column with this:
I tried and it worked like this:
Hi @Luzadriana255 ,
Please find below solution.
Best Regards,
Shreya
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
try to create a column with this:
I tried and it worked like this:
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!
Aha, then change MINX to MAXX, like this:
@amitchandak could you please help me with an advice on how to solve this. Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
43 | |
21 | |
20 | |
15 | |
13 |
User | Count |
---|---|
45 | |
41 | |
39 | |
19 | |
19 |