Forum Discussion
Date.WeekOfYear
Hi antoineL ,
Thanks for your suggestion! Please post your idea on Power BI Ideas.
It is a place for customers to provide feedback about Power BI.
What's more, if a feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
These solved something similar:
https://community.powerbi.com/t5/Desktop/how-to-adjust-week-number-in-date-dale/m-p/1598957#M647578
https://community.powerbi.com/t5/Power-Query/Calender-table-with-Date-WeekOfYear-week-53/m-p/1597115
|
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. Cheers |
Sorry I did not myself clear enough. I am not asking you how to solve that problem using custom function (which have already been written many times, although there are pitfalls). What I am pointing at is that the stock Date.WeekOfYear() function should probably be improved to be able to compute the ISO/European week number. Indeed, both threads you quoted were started because the original poster blindly assumed it would be the case.
For the benefit of people reading this thread in search of the problem you are tackling, the links you gave are leading to https://community.powerbi.com/t5/Desktop/Incorrect-week-number-at-year-end-beginning/m-p/1474322#M614369 which IMHO is a good solution (albeit I did not measure its performance impact). But such a solution ought to be temporary!
Hi antoineL ,
Thanks for your suggestion! Please post your idea on Power BI Ideas.
It is a place for customers to provide feedback about Power BI.
What's more, if a feedback is highly voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.
Best regards
Icey
If this post helps, then consider Accepting it as the solution to help other members find it faster.
(irrelevant&removed)
