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 c...
  • 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
Greg_Deckler's avatar
Greg_Deckler
Community 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
    Helper 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.