Adding column - Best Practice

[Jtaylor95]

I have created a table visual from a SP list. This list contains 'name' & 'start date' columns.

I need another column that adds 3 months onto the 'start date'.

Is it best practice to set this up using a formula in a new column on the SP list OR within PBI query editor?

[Greg_Deckler · Accepted solution]

@Jtaylor95 Depends. It's easy to do with a DAX calculated column EDATE([Date],3). Can be done other ways but that's likely the easiest and most straight-forward. However, "best practice" is to push the data transformation as close to the source as possible. But, that assumes a lot of things, like you actually have the capability to change the source...