Forum Discussion

pstanek's avatar
pstanek
Icon for Post Patron rankPost Patron
10 years ago

Need help creating number of week

Hi I use direct query within Power BI  and WEEKNUM doesn´t work because Calculated column dax formrmula doesn´t support WEEKNUM in direct query. How can I calculate it within direct Query?   I have...
Need Help
Show and Tell
Tips and Tricks
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

 pstanek

 

I reproduced same issue as yours, my power bi desktop version is 2.36.4434.381. Even I enable "unrestricted measures" in DirectQuery Option, I still get "not supported" error when adding a calculated column to get the week number from SQL table date column. 

I suggest you use DATEPART() get the week number on T-SQL query level. 

 

Regards,

elliotdixon's avatar
elliotdixon
Icon for Responsive Resident rankResponsive Resident
10 years ago

Hi v-sihou-msft how did you get on with finding a solution to this? I have allowed the unrestricted measures but still cannot get the WEEKNUM working on Direct Query mode.

 

 

Cheers,

ED.