Forum Discussion

NidhiBhusari's avatar
NidhiBhusari
Icon for Helper IV rankHelper IV
5 years ago
Solved

Difference between two date values that are in text format.

Hello, I have two rows having year values named as START YEAR and END YEAR. But these values are in text format. Can anybody please help me in calculating difference between these two values. ...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    5 years ago

    NidhiBhusari 

    you can create a column.

    Column = if('Table (2)'[endYear]="\N",blank(),int('Table (2)'[endYear])-'Table (2)'[startYear])

NidhiBhusari's avatar
NidhiBhusari
Icon for Helper IV rankHelper IV
5 years ago

ryan_mayu can you share the sample file in which you have implemented the scenario?

  • NidhiBhusari's avatar
    NidhiBhusari
    Icon for Helper IV rankHelper IV
    5 years ago

    Hey ryan_mayu Thanks for the solution...its working.

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      5 years ago

      you are welcome