Forum Discussion
pstanek
Post Patron
Post PatronNeed 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...
ankitpatira
Community Champion
Community Championpstanek I cannot replicate your issue. I have directquery to sql server and can successfully create calc column with WEEKNUM function. Ensure you have latest version of pbi desktop and go to File -> Options and Settings -> Options and check that you have allow unrestricted measure ticked.