Forum Discussion
jwin2424
Resolver I
2 years agoCount based on two date columns.
Alright. I am really hoping someone can help here. I am trying to provide a conversion rate for my opportunities. I have two seperate visuals here giving me the correct results. My ...
- 2 years ago
you can create a dim date table. Then for more than one date column, only one column's relationship can be active. Others are inactive. If you want to make those inactive relationship to be active, you can try USERELATIONSHIP function.
https://learn.microsoft.com/en-us/dax/userelationship-function-dax?wt.mc_id=DP-MVP-5004616
jwin2424
Resolver I
2 years agoI am going to mark this as the answer. I youtubed it, and this was a good explination of it.
Using USERELATIONSHIP in DAX (youtube.com)
It was specific to the different dates as well. You got me in the right direction. Thank you!
ryan_mayu
Super User
2 years agoyou are welcome