Forum Discussion
Solved
Create a custom column with a date based on another columns date
How do I write a formula that creates a new column that takes a range of dates and delivers a new date? The dates on the left are the ones that I have. I want to create a custom column with the s...
Anders_G , Try in power query like
Date.AddQuarters([Column],1)or
Date.StartOfQuarter(Date.AddQuarters([Column],1))
If this works, Mark as a solution
Anders_G , Try a new column
eomonth([Date],if( mod(Month([Date]),3) =0,0,3-1*mod(Month([Date]),3)))+1
That's brilliant. thank you!