Forum Discussion
KnowNow
Helper I
Helper ICalculate 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...
KnowNowHelper I
Helper II am new to dax. I need to select the due date from the invoice table but it is not allowing me. Is there another keword that I need for the measure to allow me to select the due date from the invoice table?
rsbin
Community Champion
Community ChampionKnowNow ,
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
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
- KnowNow
I'm sorry. I did not type the formula correctly. After correcting the formula, it works, now. Thank you so much.