Forum Discussion

NetBoulter's avatar
NetBoulter
Frequent Visitor
9 years ago
Solved

Subtract 1 working day from Date Column

I'm new so please bear with me. 

 

I have data coming in from csv (dumped from database so I don't want to do the calculation in the csv).

 

One of the columns is "Acknowledged" date. I need to calculate the "Delivery Due" date, which is the "Acknowledged" date less 1 working day. 

 

Obviously simple in Excel and will be simple for you experts but I am lost, have searched the e-learning and the community and can't find anything that I can work from. 

 

PS the reason I am not connecting direct do Database is that it is a bespoke one and I'll attack the how to do that at a later date!

 

Thanking you in advance

NetB

  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    Also simple in Powe BI. Given an [Acknowledged] column in Date format, create a new calculated column with the formula:

     

    Delivery Due = [Acknowledged] - 1

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Also simple in Powe BI. Given an [Acknowledged] column in Date format, create a new calculated column with the formula:

     

    Delivery Due = [Acknowledged] - 1
    • germanobasler's avatar
      germanobasler
      Icon for Helper I rankHelper I
      9 years ago

      Hello,

       

      What if the number of days to subtract or add is variable, so there is a column to add or subtract, would it be as simple as [Date] + [Column with number of Days]?

       

      BI simply does not accept this procedure.