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
Community Support
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

handrianto's avatar
handrianto
New Member
9 years ago

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..