Forum Discussion

Ataboyata's avatar
Ataboyata
Regular Visitor
9 years ago
Solved

Difference in Dates Measure with Info from Different Tables

Hi,  I am trying to create a measure that shows the difference between two dates. Each date is stored in a different table and they are referenced to a single ID.   For example,   Table: Shippin...
Need Help
  • Baskar's avatar
    Baskar
    9 years ago

     

     

     

     

    PLs find the image it will solve your prob 

Baskar's avatar
Baskar
Icon for Resident Rockstar rankResident Rockstar
9 years ago

 

 

 

 

PLs find the image it will solve your prob 

C097986's avatar
C097986
Icon for Helper I rankHelper I
8 years ago

I use this formula but I keep getting a result of 365 days for all columns. the difference doesn't show up.

 

Time_diff_RAtoSub = DATEDIFF(MAX('AEF_RESOURCE_ASSIGNMENT_FORM'[Resources Completed].[Date]),MAX('PRIMARY_AEF_REQUEST'[IRM_START_DATE].[Date]),DAY)

 

Result i get is 365 for each row.

 

I dont understand where i'm going wrong? Anyone, please help.

Thank you