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.
When I Go Edit Query Mode add a custom column and add the formula =WEEKNUM(Date,1) it gives me an error but It all works fine If I add the column directly from Report page.
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 .
- 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."
