How to calculate ISO week number and ISO year in DAX

ISO week number and ISO year calculation in DAX might be the best solution if you’re using the Power BI calculated table. They will give you the dimension of weeks with the same number of days and work for multiple years.

How to calculate ISO week number in Power Query

I calculated ISO week number in Power Query following instructions from Wikipedia. Here is how it goes. M code is at the end of this post.

Exit mobile version