Forum Discussion
Count based on two date columns.
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
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
I 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!