Problem with WEEKNUM function

[lavanyak]

Hello

Iam trying to get week number for a datetime value using WEEKNUM function in power BI Desktop.

Issue: For the same datetime value , the function is giving different results.Could someone please help me how to rectify this? 

Please look at the record in Red text.

BookingDate	bookingweek
1/13/2018 0:00	2
1/13/2018 0:00	2
1/13/2018 0:00	2
1/13/2018 0:00	2
1/13/2018 0:00	4
1/13/2018 0:00	2

Any help is much appreciated!

[Anonymous]

Hi @lavanyak,

I test with same date but not face the issue, can you please share a same pbix file to test?

Regards,

Xiaoxin Sheng

[lavanyak · Accepted solution]

Hi Xiaoxin Sheng,

Thanks for your time , I really appreciate it.

The issue is resolved and evrything is working fine now.I dont know what the issue was , but when I tried couple of times it came out correctly.

I cannot send the pbix file as well, because that has been corrected and I dont have the old data.

Thanks

Lavanya