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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Nikhil1106
New Member

Need help creating week number

 

I found 'week of year' and 'week of month' under Date section in Add column.


Is there a way to find week of Quarter from a given date either through DAX formula or  query editor?

1 REPLY 1
waltheed
Impactful Individual
Impactful Individual

I do not know of any DAX function that does exactly that. 

 

But the recommended approach is to create a data dimension table yourself. And then  you can add any column or type of date  property you like. 

 

Here is a nice post on how to do that with Power Query (get data):

https://blog.crossjoin.co.uk/2013/11/19/generating-a-date-dimension-table-in-power-query/

 

 

Cheers, Edgar Walther
ITsmart BI and Analytics consultant

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.