Forum Discussion
Jtaylor95
3 years agoRegular Visitor
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...
- 3 years ago
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...
Greg_Deckler
3 years agoCommunity Champion
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...