Forum Discussion

harshad_barge's avatar
harshad_barge
Icon for Helper I rankHelper I
6 years ago
Solved

DAX incorrectly calculating DATEADD condition

Hi all,  I am still discovering DAX and I am incredibly grateful for the support of this forum so far. I have a problem I dont know why i am not getting an output for just a few of the values. I can...
Need Help
  • danextian's avatar
    danextian
    6 years ago

    Hi harshad_barge ,

     

    If you are simply trying to get the difference in years between two dates, you can just use DATEDIFF().

    Position from (Year) =
DATEDIFF ( 'Table'[Calculation Date], 'Table'[Position From Date], YEAR )

     

danextian's avatar
danextian
Icon for Super User rankSuper User
6 years ago

Hi harshad_barge ,

 

If you are simply trying to get the difference in years between two dates, you can just use DATEDIFF().

Position from (Year) =
DATEDIFF ( 'Table'[Calculation Date], 'Table'[Position From Date], YEAR )