Solved: Get date end using Language M

Anonymous · ‎01-07-2021

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 · ‎01-07-2021

@Anonymous , Try new column

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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

parry2k · ‎01-07-2021

@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.⚡

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.