Forum Discussion
Rashid Mohammed
Aug 23, 2016Brass Contributor
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
- Aug 24, 2016
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 .
TrebGatte
Sep 06, 2016MVP
In the Query Editor, select the date column. Go to the Add column tab. Under the Date button on the right side of the ribbon, select Week, then week of the year. That's the week number equivalent.