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

[krrish116]

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...

[Sumanth_23 · Accepted solution]

@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!