MAX of Logic or zero

[sovereignauto]

Afternoon,

So i am trying to convert an Excel sheet to Powerbi.

I have a formular that uses MAX for max([logic calculation],0) so if the calculation is less that zero it will equal zero.

How would i do this in powerBI? 

The calculation is [date 1]-[date 2] i have created a column with this in already but now not sure what to do! 

[jdbuchanan71 · Accepted solution]

In your column you could do

Column = 
VAR _calc = [date 1]-[date 2]
RETURN
IF ( _calc < 0, 0, _calc )