if date plus 15 minutes greater than date need help!!!

[Syah_Adrian]

Need helps

Hi, i newbie power BI

i have a case to calculate below formula
if date (A) plus 15 minutes greater than date (B) than Yes else if No

can you help me to describe on DAX function

thanks

[MarcoPessina]

Hi @Syah_Adrian ,

you can also use the DATEDIFF function like this:

CalculatedColumn = IF(DATEDIFF(Table[Date(A)],Table[Date(B)],MINUTE)>15,"Yes","No")

Cheers,

Marco

[Syah_Adrian]

till have a error

"A single value for column 'Date(A)' in table 'Table1' cannot determined..."

[Syah_Adrian]

my table is CMDB_Incident have column reported_date and created_date

i want to see if reported_date + 15 minutes greater than created_date or no 

i already use 
CalculatedColumn = IF(DATEDIFF(Table[Date(A)],Table[Date(B)],MINUTE)>15,"Yes","No")

and
if((Table[Date A] + time(0,15,0))>Table[Date B] ,"Yes","No")

still have error
A single value for column 'Date(A)' in table 'Table1' cannot determined..."

[amitchandak · Accepted solution]

@Syah_Adrian ,

Try like

if((Table[Date A] + time(0,15,0))>Table[Date B] ,"Yes","No")

[Syah_Adrian]

sory after i look in again this method is correct

thanks !!!

[Syah_Adrian]

still have a error

and i forgot to mention, after that function succeed i want to calculate total "Yes"