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

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