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 .
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 .