Forum Discussion
Multiple Date Columns and USERELATIONSHIP
Noah I would probably go with a disconnected (unrelated) date table and then form the relationship in a measure checking first for Date completed but if BLANK, check a different date.
You might be able to use USERELATIONSHIP. You would need to form relationships between your date table and all the date columns in the table with the active relationship being Date Completed. Would be a simplar process of checking of Date Completed is blank and then using CALCULATE with USERELATIONSHIP.
IMHO, the first approach is going to be easier to do and debug.
Noah I would probably go with a disconnected (unrelated) date table and then form the relationship in a measure checking first for Date completed but if BLANK, check a different date.
You might be able to use USERELATIONSHIP. You would need to form relationships between your date table and all the date columns in the table with the active relationship being Date Completed. Would be a simplar process of checking of Date Completed is blank and then using CALCULATE with USERELATIONSHIP.
IMHO, the first approach is going to be easier to do and debug.
Hello, Greg_Deckler
I have that considered as my end of the line solution. I want to avoid trying to use up more real estate doing just that if I can, seeing as it's been an issue I have faced before with other projects and I regret not coming up with a cleaner, more elegant solution.
If push comes to shove, well, guess I'll do just that! Thanks for your response though.