Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have the the following data :
response_timestamp | id | status | infos |
26/10/2023 4:30 PM | 1 | active | ... |
26/10/2023 4:31 PM | 2 | inactive | ... |
26/10/2023 4:33 PM | 3 | active | ... |
I would like to keep the minimum response_timestamp but can't figure out the M code to do so. I have calculated the minimum with List.min() function but don't know how to assign it to a new column...
The expected result would be :
response_timestamp | min_response_timestamp | id | status | infos |
26/10/2023 4:30 PM | 26/10/2023 4:30 PM | 1 | active | ... |
26/10/2023 4:31 PM | 26/10/2023 4:30 PM | 2 | inactive | ... |
26/10/2023 4:33 PM | 26/10/2023 4:30 PM | 3 | active | ... |
Solved! Go to Solution.
Hi @Geek0874
= Table.AddColumn(#"PreviousStepName", "Min_response_timestamp", each List.Min(Table[response_timestamp]))
Hi @Geek0874
= Table.AddColumn(#"PreviousStepName", "Min_response_timestamp", each List.Min(Table[response_timestamp]))