need help this dax
1 Topic
Need help dax measure
I have columns such as Plant, Container Number, Predicted Delivery Date, Maximum ETA Date, and Free Days. I need a DAX measure in Power BI that, for each market, calculates the difference between the Predicted Delivery Date and the Maximum ETA Date. If this difference exceeds the Free Days, it should return the number of days; otherwise, it should return a blank. PLANT Container Number Max of ETA Predicted_Delivery_Date FT DAYS Australia TGBU51141 15-07-2025 18-07-2025 6 Australia #AFH40 27-06-2025 30-06-2025 6 Australia PIDU4269 11-07-2025 14-07-2025 6 Australia PIDU4269 11-07-2025 14-07-2025 6 China TWCU819 15-04-2025 19-04-2025 7 China TEMU800 07-01-2025 11-01-2025 7 China SELU4275 29-12-2024 02-01-2025 7 Japan CCLU5181 24-01-2025 29-01-2025 4 Japan OOCU4931 07-03-2025 12-03-2025 4 Japan OOCU4931 07-03-2025 12-03-2025 4 Japan CCLU529 23-05-2025 28-05-2025 4 Japan FSCU506 23-05-2025 28-05-2025 4 Philippines SEKU652 17-05-2025 22-05-2025 10 Philippines CSNU401 26-05-2025 31-05-2025 10 Philippines CBHU6474 17-03-2025 22-03-2025 10 Thailand OOLU4416 11-01-2025 15-01-2025 10 Thailand OOCU489 17-05-2025 21-05-2025 10 Thailand DFSU135 16-04-2025 19-04-2025 10 Vietnam OOCU065 07-04-2025 11-04-2025 5 Vietnam CSLU190 19-05-2025 23-05-2025 5Solved2.2KViews2likes12Comments