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 still not sure how that will work in the visual. Which date would go in the rows?
then could you pls provide some sample data?
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!you are welcome
