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])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

NidhiBhusari , In power query you have the option to clean the data, use that that will remove \N (return),

 

Then change the data type to text and try.

Under data tranform -(power query) -> Tranform tab -> clean