Forum Discussion
Solved
Date Comparison between two Related Tables
I have searched this forum, but I believe I have a very basic request. I have shimmied down my data model. I have a fact table (factCase) with a date (TIncision_DT) and a dimension table (dimQu...
Hi dkernen ,
You could use DATEDIFF() function.
https://docs.microsoft.com/en-us/dax/datediff-function-dax
Example:
Measure = DATEDIFF(SELECTEDVALUE(factCase[TIncision_DT]),SELECTEDVALUE(dimQuality[QTProcessorReview_DT]),DAY)Best Regards,
Jay
Hi dkernen ,
You could use DATEDIFF() function.
https://docs.microsoft.com/en-us/dax/datediff-function-dax
Example:
Measure = DATEDIFF(SELECTEDVALUE(factCase[TIncision_DT]),SELECTEDVALUE(dimQuality[QTProcessorReview_DT]),DAY)
Best Regards,
Jay
Thank you! The was the only solution that worked - and worked without creating a new column. You're incredible! Thank you!