Forum Discussion

KnowNow's avatar
KnowNow
Icon for Helper I rankHelper I
2 years ago
Solved

Calculate weekday based on due date

I need to create a dax measure that shows the closest Tuesday and Thursday of every week from an invoice due date. For example, if the invoice due date is Saturday, 09/30/2023, then the closet Tuesda...
Need Help
  • rsbin's avatar
    rsbin
    2 years ago

    KnowNow ,

    Please Accept as Solution to close out the thread.

    Best Regards,

rsbin's avatar
rsbin
Icon for Community Champion rankCommunity Champion
2 years ago

KnowNow ,

Apologies, I should have clarified that this is a Calculated Column added to your Invoice Table - not a Measure.

Have attached a simple pbix file so you can see more clearly.

Regards,

KnowNow's avatar
KnowNow
Icon for Helper I rankHelper I
2 years ago

Thank you but now I am getting the error "switch does not support comparing values of type true/false with values of type integer. Consider using the VALUE or FORMAT function to convert one of the values