Forum Discussion
NidhiBhusari
Helper IV
Helper IVDifference 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. ...
you can create a column.
Column = if('Table (2)'[endYear]="\N",blank(),int('Table (2)'[endYear])-'Table (2)'[startYear])
ryan_mayu
Super User
Super Useryou can create a column.
Column = if('Table (2)'[endYear]="\N",blank(),int('Table (2)'[endYear])-'Table (2)'[startYear])- NidhiBhusari
ryan_mayu can you share the sample file in which you have implemented the scenario?
- ryan_mayu
pls see the attachment below
- NidhiBhusari
Hey ryan_mayu Thanks for the solution...its working.