Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

0

[ISSUE ]WeekNum parameter incorrect for Power BI Web

Based on MS site,https://learn.microsoft.com/en-us/dax/weeknum-function-dax this should work

nic_k_1-1691721673217.png

 

This is my input in Power BI web, returning an error

nic_k_0-1691721564145.png

 

Status: Delivered
Comments
Anonymous
Not applicable

Hi @nic_k ,

 

I'd like to know what of your drop down options you were able to select when you wrote this dax?

vxiaoyanmsft_0-1692003937653.png

 

Best regards.
Community Support Team_Caitlyn

 

nic_k
Frequent Visitor

Hi,

 

I only have  the option for 1 and 2

nic_k_0-1692062976478.png

 

I'm also having different error messages for both DAX and calculated columns

 

-Calculated columns:

nic_k_1-1692063030715.png

 

-DAX

nic_k_2-1692063072191.png

 

 

For additional context:

i. This data is using a direct query from Dynamics CRM

ii. The column 'Created On' is using a date/time format as below

     nic_k_3-1692063189998.png

 

 

 

 

 

Anonymous
Not applicable

Hi all,

 

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Best regards.
Community Support Team_Caitlyn

Anonymous
Not applicable

Update:

 

 

This issue is still in investigating.

 

 

Best Regards,
Community Support Team _ Caitlyn

Anonymous
Not applicable

Hi @nic_k ,

 

This issue has been fixed,please try it later.

 

Best regards.
Community Support Team_Caitlyn

nic_k
Frequent Visitor

resolved. thank you