Forum Discussion

andrew_hardwick's avatar
andrew_hardwick
Icon for Helper III rankHelper III
9 years ago

Comparing dates in a table

I have created a measure to create the difference between 2 dates in seperate tables. The first table holds the records that were created, the second table holds when the fields in table 1 were chang...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

andrew_hardwick

 

In this scenario, you could use calculated column instead of  measure. It will be much easier to achieve you logic. Just apply IF statement like:

 

Column =
1
    * (
        IF (
            Table[Changed Date] <> BLANK (),
            Table[Changed Date],
            IF ( Table[Closed Date] <> BLANK (), Table[Closed Date], NOW () )
        )
            - Table[Open Date]
    )

Regards,