How do I write a DAX formula to calculate the date difference between two columns. The calculate column should be name OnTime and if true should be Y, if not, N. The difference should be in minutes. There's a fix target value which is 30 minutes divided by 1440 (number of minutes in a day)

See the formula in excel below

=IF(ISBLANK(F5),"",IF(ABS((F5-E5)<(Targets!$E$4/1440)),"Y","N"))

enter image description here

1 Answer

You can create a new COLUMN using the following DAX-

On-Time? = IF( ISBLANK('your_table_name'[plan]), BLANK(), IF( DATEDIFF('your_table_name'[plan],'your_table_name'[actual],MINUTE) < 30/1440, "Y", "N" ) )

Sample output will be like-

enter image description here

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.