Forum Discussion
Solved
subtract time difference dax
Hi , I would like to create a column to show the values as 1 if the time difference between the current time and the recorded times in the table is between 0 to 30 mins. ,meaning to say I want to s...
Hi,you can use this dax :
Is IN 30Minutes = IF((now()-Sheet1[date])*24<=0.5,1,0)Anonymous , thanks a lot. modified my table to datetime and it worked.thanks.
Hi,you can use this dax :
Is IN 30Minutes = IF((now()-Sheet1[date])*24<=0.5,1,0)
Anonymous , thanks a lot. modified my table to datetime and it worked.thanks.