Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
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!
Solved! Go to Solution.
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! |
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! |