Use DateAdd to calculate if statement on Expiry product

[Anonymous]

I have a field that contains expiry date for items, and another date that contains warning before expiry. This is important to make the stock controller who which product is about to expiry. 

I need to construct a good Dateadd calculation that will give three status against today, Expired, Closed to Expiry and Ok 

this is what we have done in SQL but reconstructing in Powerbi is proving a challenge. 

case
when dateadd(day,1, constants.today) >= PartLot.ExpirationDate then '*** EXPIRED!!!***'
when dateadd(day,PartClass.Alert1_c, constants.today) > PartLot.ExpirationDate then '*** CLOSED TO EXPIRY !!!***'
when dateadd(day,PartClass.Alert1_c + 400, constants.today) > PartLot.ExpirationDate then '*** OK!!!***'
else '*** CHECK EXPIRY DATE !!!***'
end

[PattemManohar]

@Anonymous  Please try something like this... 

IF(
    DATEADD(constants.today,1,DAY) >= PartLot.ExpirationDate,"*** EXPIRED!!!***",
	IF(DATEADD(constants.today,PartClass.Alert1_c,DAY) > PartLot.ExpirationDate,"*** CLOSED TO EXPIRY !!!",
		IF(DATEADD(constants.today,PartClass.Alert1_c+400,DAY) > PartLot.ExpirationDate, "*** OK!!!***")
	  )
  )
	

[Anonymous]

this looks more like a sql function, formatting it to a DAX returns errors

[Anonymous]

Hi

I just wanted to check, you want to do this in a custom column, rather than a measure right?

Thanks

[Anonymous]

yes pls