cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors