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,

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

Where can I find T SQL level?

 

File -> Options and Settings -> Options and check that you have allow unrestricted measure ticked.

Is this safe? I am afraid of incorrect results.