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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
krrish116
Resolver II
Resolver II

Extract Years, Months and Quarters from a date in direct query

Hi @amitchandak , @Greg_Deckler ,

We have a Date in DateFormat of time stamp and i want to extract date, months, quarters and Years .

It is in Direct Query that is the main Problem Over Here..

Please guide me on this..

Thanks,

Krish...

1 ACCEPTED SOLUTION
Sumanth_23
Memorable Member
Memorable Member

@krrish116  - You can do the same using calculated columns using the functions mentioned below: 

 

Year_test = YEAR('Date'[Date ID])

Qtr_test = QUARTER('Date'[Date ID])

Month_test = MONTH('Date'[Date ID])

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



View solution in original post

1 REPLY 1
Sumanth_23
Memorable Member
Memorable Member

@krrish116  - You can do the same using calculated columns using the functions mentioned below: 

 

Year_test = YEAR('Date'[Date ID])

Qtr_test = QUARTER('Date'[Date ID])

Month_test = MONTH('Date'[Date ID])

 

Please mark the post as a solution and provide a 👍 if my comment helped with solving your issue. Thanks!

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!

Proud to be a Super User!



Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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