inconsistent weekend weekday DAX calculated value

[handrianto]

I use DAX function: GetWeekDay = WEEKDAY(WEEKDAY([DropOffTimeLocal].[Date],2)) to get the weekday value. Apparently, it has  different result for the same day. for the same March 3, 2017 and March 10, 2017. the weekday function return 2 different values. wheres it is a Friday (value 5), instead some of them return Saturday (value 6)

Is it a bug in function or not ?

Thanks a lot for your response..

[v-qiuyu-msft · Accepted solution]

Hi @handrianto,

I notice that the date place in the table visual is [PickUpTimeLocal], while the GetWeekDay = WEEKDAY([DropOffTimeLocal].[Date],2).

And I also find there are records [PickUpTimeLocal] date is not equal to the [DropOffTimeLocal] date. As you compare the [PickUpTimeLocal] date with the weekday value from the [DropOffTimeLocal], the result you get is expected.

Best Regards,
Qiuyun Yu

[handrianto]

Ah.. How can I do such silly mistake.. I copy paste the DAX from other BI report and forgot to change the column reference from droptime into pickuptime. didn't catch that for 2 days.

Thank you very much for your help Quiyu..

[handrianto]

Hi Qiuyun Yu, Thanks for the response. I've already update PBI Desktop to the latest update May 2017. I've corrected the DAX function (silly me) as you suggest. GetWeekDay = WEEKDAY([DropOffTimeLocal].[Date],2). but apparently after re-run the function and I checked the table test result; it is still the same.

in fact now I notice it is randomly occur in other dates.

DAX functionPBI Desktop Version8 march9 March10 March

[v-qiuyu-msft]

Hi @handrianto,

In your scenario, please remove the one WeekDay() function and keep only one like below:

GetWeekDay = WEEKDAY(WEEKDAY([Date].[Date],2))

Also please try to run the desktop version latest one 2.46.4732.721 64-bit (May 2017). If issue persists, please share .pbix file if possible.

Best Regards,
Qiuyun Yu