- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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...
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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...
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-02-2024 07:03 AM | |||
06-05-2024 04:28 PM | |||
06-25-2024 09:22 AM | |||
10-16-2024 01:39 PM | |||
07-08-2023 08:57 AM |
User | Count |
---|---|
141 | |
110 | |
81 | |
61 | |
46 |