The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
@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...
@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...