Calcaluted columan based on if statment

[Anonymous]

This is in Excel and i want the same as calculated columan in power bi

=IF(Status="Under Review",TODAY()-Date Submiited ,Response Date-Date Submiited)

Please help

[Anonymous · Accepted solution]

Hi,

Use this:

Column = IF(Status="Under Review",DATEDIFF(Table[Date Submiited],TODAY(),DAY) ,DATEDIFF(Table[Date Submiited],Table[Response Date],DAY)

You can change the interval as you need.

Thanks.