Aug 23 2016 07:47 AM
Is there any way to find the Week Number from a Date field using a custom column in POWER BI desktop app
Aug 23 2016 08:00 AM
Aug 23 2016 10:03 PM
Aug 23 2016 11:33 PM
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.
Aug 24 2016 02:22 AM
SolutionThese 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 .
Sep 06 2016 09:30 AM
Aug 24 2016 02:22 AM
SolutionThese 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 .