Forum Discussion

handrianto's avatar
handrianto
New Member
9 years ago
Solved

inconsistent weekend weekday DAX calculated value

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...
Data Modeling
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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