Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

 

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you!  The was the only solution that worked - and worked without creating a new column.  You're incredible!  Thank you!