Skip to main content

Power BI

Needs Votes

The addition of ISOWEEKNUM to DAX

Vote (15) Share
Jasper van den Berg's profile image

Jasper van den Berg on 20 Apr 2021 09:08:26

As you might now WEEKNUM is the format used mainly in the United States, while Europeans like me use the ISOWEEKNUM function. Currently both ISOWEEKNUM and WEEKNUM are supported in Excel, yet Power BI only has support for the WEEKNUM function.

If you work at a European company, the WEEKNUM function simply does not work as we would want it to and therefore we have to write a lot of DAX to get accurate results. The addition of an ISOWEEKNUM function would help massively with creating week-based reports. It would make them more convenient, and more accessible to those not fully acquainted with DAX.

Comments (2)
Jasper van den Berg's profile image Profile Picture

Adam Vero on 26 Nov 2021 13:47:25

RE: The addition of ISOWEEKNUM to DAX

See also: https://ideas.powerbi.com/ideas/idea/?ideaid=9e89447d-7b65-eb11-8fed-281878e608e9

Jasper van den Berg's profile image Profile Picture

Jasper B on 20 Apr 2021 09:25:20

RE: The addition of ISOWEEKNUM to DAX

*"know", not "now".