Forum Discussion
RobThrive
6 years agoResolver I
Matrix values using two different date columns.
Hello, I'm stuck, and hoping someone can assist please. I'm not even sure how to word the problem/scenario. 😕 I have a fact table with a date column of "target_date_completion" which m...
- 6 years ago
RobThrive , You can create a date table and join it with both dates. Keep the most used on as active and another one inactive. You can use userelation in a measure to activate a relation
refer
amitchandak
6 years agoSuper User
RobThrive , You can create a date table and join it with both dates. Keep the most used on as active and another one inactive. You can use userelation in a measure to activate a relation
refer
RobThrive
6 years agoResolver I
amitchandak , you, good sir have just elevated my DAX game to the next level!
Implementing this change to my existing measure was so fast and simple once I read those articles to understand it.
Thank you so much.