Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anders_G
Helper I
Helper I

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 starting date of the next quarter, based on the "Initial date" column. So whichever quarter the "Initial date" falls within the custom column will provide the first day of the next quarter. Q1 = Jan-Mar, etc.

 

The custom column needs to be visible in Power Query.

 

Anders_G_0-1659534249233.png

 

Thank you

 

1 ACCEPTED SOLUTION

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@Anders_G , Try a new column

eomonth([Date],if( mod(Month([Date]),3) =0,0,3-1*mod(Month([Date]),3)))+1

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Ran in to a problem. I wasn't aware of at the time of writing my initial question. But I need the custom column created to be visible in Power Query. Unfortunately this calculated DAX column is not visible.

@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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

That's brilliant. thank you!

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

May 2025 Monthly Update

Fabric Community Update - May 2025

Find out what's new and trending in the Fabric community.