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)
RE: The addition of ISOWEEKNUM to DAX
See also: https://ideas.powerbi.com/ideas/idea/?ideaid=9e89447d-7b65-eb11-8fed-281878e608e9
RE: The addition of ISOWEEKNUM to DAX
*"know", not "now".