Calclulating Days between 2 dates in the edit query

[Anonymous]

Hey,

Is there a way that I can calculate the number of days between 2 dates in the edit query option itself. The DatedIFf Formula does not work in the add custom columns. It says it cannot be recognized.

Is there any other syntax or formula that can be used? Thank You!

[Zubair_Muhammad · Accepted solution]

@Anonymous

Try with following custom column

=Duration.Days(Duration.From([End]-[Start])))