Forum Discussion
Need remark dates in one column based on another column.
ritar_li good to hear, accept the solutions so that others can take advantage of this as well.
✨ Follow us on LinkedIn and to our YouTube channel
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.
Super Userritar_li I think this is what you are looking for:
New Column =
IF ( EOMONTH ( Table[Completed Date], 0 ) = DATE(2022,1,31) && Table[Billing Date] = DATE(2022,03,31 ), DATE(2022,2,15), Table[Billing Date] )
✨ Follow us on LinkedIn and to our YouTube channel
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.
Thank you so much. It works.
