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 try this calculated column:
New Column =
IF ( EOMONTH ( Table[Completed Date], 0 ) = DATE(2022,1,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 perfectly.
However, I found new problem. Billing team also send some invoices in 1/26/2022. I listed in a new table below. If I use the DXA you provided, the total charges/per month shift.
How can I fix this problem?
Service ID | Complete date | Billing date | Billing date-mod |
1 | 1/5/2022 | 3/31/2022 |
|
2 | 1/5/2022 | 3/31/2022 |
|
3 | 1/7/2022 | 3/31/2022 |
|
4 | 1/10/2022 | 3/31/2022 |
|
5 | 2/5/2022 | 3/31/2022 |
|
6 | 2/10/2022 | 3/31/2022 |
|
7 | 2/10/2022 | 3/31/2022 |
|
8 | 2/15/2022 | 3/31/2022 |
|
9 | 1/6/2022 | 1/26/2022 |
|
10 | 1/2/2022 | 1/26/2022 |
|
11 | 1/4/2022 | 1/26/2022 |
|
- Ashish_Mathur
Hi,
Clearly show the expected result in another column.
