Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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!!!***") ) )
Proud to be a PBI Community Champion
this looks more like a sql function, formatting it to a DAX returns errors
Hi
I just wanted to check, you want to do this in a custom column, rather than a measure right?
Thanks
yes pls
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |