Using if Clauses

[Anonymous]

Hello, 
I wanted to know if somebody knows how to deal with this. I am pretty new to PowerBI Dax, which is why this seemingly simple problem is hard to solve..
So I want to calculate the "delay" column. The calculation should only happen when"Hello" is written into the "Project" column.
The calculation should be Todays Date - Milestone Date. So I want to display the amount of days between the milestone and today's date

Thank you for your help!

[johnt75 · Accepted solution]

Create a measure like

Delay = 
var currentMilestone = SELECTEDVALUE('Table'[Milestone])
return IF( SELECTEDVALUE('Table'[Project]) = "Hello" && currentMilestone < TODAY(), TODAY() - currentMilestone)

and make sure to set the type of the measure to Whole Number