Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
ID | State | ChangeDate |
1 | Proposed | 08-03-2024 00:00 |
1 | Proposed | 09-03-2024 00:00 |
1 | Analysis | 25-03-2025 00:00 |
1 | Authoring | 26-03-2025 00:00 |
1 | Authoring | 27-03-2025 00:00 |
1 | Blocked | 06-02-2025 00:00 |
1 | Blocked | 07-02-2025 00:00 |
1 | Analysis | 08-02-2025 00:00 |
2 | Proposed | 08-03-2024 00:00 |
2 | Authoring | 25-03-2025 00:00 |
2 | Analysis | 29-07-2024 00:00 |
2 | Blocked | 06-02-2025 00:00 |
2 | Blocked | 07-02-2025 00:00 |
2 | Authoring | 08-02-2025 00:00 |
Id | State | MinChangeDate |
1 | Proposed | 08-03-2024 00:00 |
1 | Analysis | 25-03-2025 00:00 |
1 | Authoring | 26-03-2025 00:00 |
1 | Blocked | 06-02-2025 00:00 |
1 | Analysis | 08-02-2025 00:00 |
2 | Proposed | 08-03-2024 00:00 |
2 | Authoring | 25-03-2025 00:00 |
2 | Analysis | 29-07-2024 00:00 |
2 | Blocked | 06-02-2025 00:00 |
2 | Authoring | 08-02-2025 00:00 |
Solved! Go to Solution.
Hi,
This M code in Power Query works
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"State", type text}, {"ChangeDate", type date}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"ID", "State"}, {{"Count", each List.Min([ChangeDate]), type nullable date}},GroupKind.Local)
in
#"Grouped Rows"
Hope this helps.
Hi,
This M code in Power Query works
let
Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"ID", Int64.Type}, {"State", type text}, {"ChangeDate", type date}}),
#"Grouped Rows" = Table.Group(#"Changed Type", {"ID", "State"}, {{"Count", each List.Min([ChangeDate]), type nullable date}},GroupKind.Local)
in
#"Grouped Rows"
Hope this helps.
Hi @Pravdba ,
If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!
Hi @Pravdba ,
We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.
If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
If you still have any questions or need further assistance, feel free to let us know — we're happy to help!
Thank you!
Hi @Pravdba ,
If a community member's response addressed your query, please consider marking it as Accepted Answer and click Yes if you found it helpful.
If you have any further questions, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!