Forum Discussion

ritar_li's avatar
ritar_li
Frequent Visitor
4 years ago
Solved

Need remark dates in one column based on another column.

Hi, Our billing team billed services for Jan and Feb together on 3/31/2022. Now I need to separate those services occurred in Jan from services completed in Feb. First step, I convert the “complete...
Need Help
  • parry2k's avatar
    parry2k
    4 years ago

    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.

ritar_li's avatar
ritar_li
Frequent Visitor
4 years ago

Hi,

I'm sorry for confusion. 

I want to create a billing date column.

Some service charges, which were completed in the beginning of Jan 2022, were invoiced on 1/26/2022. I want to keep those services' billing dates as 1/26/2022. I want services which completed in Jan 2022 and billed on 3/31 use billing date 2/15/2022. The rest of billing dates keep as it is. 

Hope I make my question is clear. 😀

Thanks again.