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)
Go to Solution.
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.
View solution in original post
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.