Forum Discussion

igorabdo's avatar
igorabdo
Advocate II
8 years ago
Solved

Sum Days

Hi everybody I'm try to understand a query with date. I'm working with financial data. I've three bank. Bank 1 Bank 2 Bank 3 And I receive this Bank 1 - Receipts one day after maturity = D + ...
Need Help
  • igorabdo's avatar
    igorabdo
    8 years ago

    Hi!!! 
    I got it!

    It's simple.

    I use M language.

     

    if [Banco] = "Safra" then Date.AddDays([Data pagamento],1) else Date.AddDays([Data pagamento],3)

     

    Date.AddDays save me

     

    Thanks everyone

Anonymous's avatar
Anonymous
Not applicable
8 years ago

igorabdo,

Could you please share sample data of your table and post expected result based  on the sample data here?

Regards,
Lydia

    • alexei7's avatar
      alexei7
      Continued Contributor
      8 years ago

      Hi igorabdo,

       

      Sorry, I've looked at your model and your posts and still don't understand your requirement.

       

      Perhaps you could fill out the column with your expected result to help us understand what you're trying to do

       

      Thanks

      Alex

    • pnvinod's avatar
      pnvinod
      Helper I
      8 years ago

      Hi,

       

      You can use a Custom Column as below

       

      NewDate = if(Orders[Banko] = "Safra",Orders[Order Date] +3,Orders[Order Date] +1)

       

      Please change "Orders" to your Table Name and

      "Order Date" to field name in your file

       

      Let me know if it works

       

       

      • igorabdo's avatar
        igorabdo
        Advocate II
        8 years ago

        Hi!!! 
        I got it!

        It's simple.

        I use M language.

         

        if [Banco] = "Safra" then Date.AddDays([Data pagamento],1) else Date.AddDays([Data pagamento],3)

         

        Date.AddDays save me

         

        Thanks everyone