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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Solution Supplier
Solution Supplier

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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