Forum Discussion
Solved
Is there any replacement for WEEKNUM in Power BI
Is there any way to find the Week Number from a Date field using a custom column in POWER BI desktop app
These are different tools, with Query you use M language and with model DAX. Check query function here https://msdn.microsoft.com/en-us/library/mt253480.aspx .
Rashid, didn't catch, replacement of what? WEEKNUM in DAX works fine, or you mean Power Query? Here is also some function.
I am trying to get the WEEKNUM from a date column by adding a custom column in power BI. "WEEKNUM([Date],2)" gives me an error in Power BI "Expression error: The name 'WEEKNUM' wasn't recognized. Make sure it's spelled correctly."