Forum Discussion
Adding column - Best Practice
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?
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...
1 Reply
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...