The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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]))
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
19 | |
18 | |
17 | |
13 |