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.
I have a worklflow which assigns a phase (Phase A) to multiple people simultaneously. Each person may approve the workflow on a different date. I need to calculate the days between the last approval of this phase and the completion date of the following phase. To do this, I'd like to create a column that displays the most recent approval date from multiple columns. Can someone tell me how I can display this date?
Record ID | Supervisor Date | Engineer Date | Writer Date | Most Recent Date |
Record 123 | 4/1/21 | 4/18/21 | 4/7/21 | Find most recent date |
Solved! Go to Solution.
@ddownard , Try a new column like
Switch( True(),
[Supervisor Date] > [Engineer Date] && [Supervisor Date] > [Writer Date], [Supervisor Date],
[Engineer Date] > [Writer Date] ,[Engineer Date] ,
[Writer Date]
)
The solution from @amitchandak is the solution that produces the desired results. Hoping someone can tell me how to add three more columns to amitchandak's solution. Thanks!
Hi @ddownard
Please correct me if I wrongly understood your question.
According to your description, you hope to find the largest date in the three date columns and return this value .I create a measure that may meet your needs .
Measure = MAXX({MAX('Table'[Supervisor Date]),MAX('Table'[Engineer Date]),MAX('Table'[Writer Date])},[Value])
The effect is as shown:
Best Regards
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks @amitchandak. That worked! Would you mind telling me what to add for this to work with three additional date columns?
Go to query editor and duplictate the date all date column. and convert duplicate date column in to the data type as whole number.
select all duplicate date column (converted into the whole number) and click add column --> statistics --->Maximum.
Now change date type into Date to get the most recent date.
@ddownard , Try a new column like
Switch( True(),
[Supervisor Date] > [Engineer Date] && [Supervisor Date] > [Writer Date], [Supervisor Date],
[Engineer Date] > [Writer Date] ,[Engineer Date] ,
[Writer Date]
)
@amitchandak , can you tell me how to change your code to include three additional columns?
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 |
---|---|
100 | |
99 | |
76 | |
66 | |
61 |
User | Count |
---|---|
142 | |
106 | |
103 | |
85 | |
70 |