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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
crln-blue
Post Patron
Post Patron

Calculate number of weeks in a year

Hello!

Not sure where to post this but here it goes.

I'm creating a custom column in power query where I need to make a list of numbers. My start number is 1 but my end number varies, which is dependent on the number of weeks in a current year.

 

Here is my code:

crln-blue_1-1608449715021.png

 

What I would like to be is 

=List.Numbers(1, (# of weeks in current year: year(now))

 

How do I compute this? Thanks for the help!

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

Hi, @crln-blue , you might want to use this code

= {1..Date.WeekOfYear(DateTime.LocalNow())}

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

2 REPLIES 2
CNENFRNL
Community Champion
Community Champion

Hi, @crln-blue , you might want to use this code

= {1..Date.WeekOfYear(DateTime.LocalNow())}

Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

Hello @CNENFRNL ! Thanks for this!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors