Power Bi Dax Datediff Calculation
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...
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"))
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-
James Sterling reports on renewable energy developments, climate policy, ecological conservation, and green tech innovations around the globe.
