Get date end using Language M

[Anonymous]

Hi,
I have a table below:

I need to build one column with date end status. This date is obtained thus:
1- With date started of next status date.
2- If there isn´t next status, the date end is date now.

I need to have column as:


Someone can help me to build this column using the language M (power bi query).
Thanks

[amitchandak · Accepted solution]

@Anonymous , Try new column

new column = coalesce( minx(filter(Table, [id project] = earlier([id project]) && [Date started] > earlier([Date started])),[Date started]), today())

[parry2k · Accepted solution]

@Anonymous Power Query solution for next date is attached. Tweak it as per your need.

Check my latest blog post Year-2020, Pandemic, Power BI and Beyond to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[amitchandak · Accepted solution]

@Anonymous , Try new column

new column = coalesce( minx(filter(Table, [id project] = earlier([id project]) && [Date started] > earlier([Date started])),[Date started]), today())

[Anonymous]

Thanks,
It´s possible to make this using language M e not DAX?