Displaying Date with time in slicer

[Anonymous]

I have start date time and end date  time on my report i want to display below conditions in my report.

EVENT_START_DATETIME <= today date and time (user input date time)
EVENT_END_DATETIME >= today date and time (user input date time)

[amitchandak · Accepted solution]

@Anonymous , A measure like the given example. where date filter might come from an independent date table ( or we need to do necessary changes )

measure =
var _max = maxx(allselected('Date'), 'Date'[Date])
return
calculate(countrows(Table) , filter ( Table, (Table[EVENT_START_DATETIME] <= Today() && Table[EVENT_START_DATETIME] <=_max) && (Table[EVENT_END_DATETIME] >= Today() && Table[EVENT_END_DATETIME] >=_max)))

[Anonymous]

Hi Amit, i have tried this measure but its not giving proper results and returning numbers. Here am pulling data from view  and i dont have date table in my report.

StartEnDTiMe =

var _max = maxx(allselected('egama NGESO_PreBuilt_OLTA_BMU'), 'egama NGESO_PreBuilt_OLTA_BMU'[EVENT_START_DATETIME])

return

calculate(countrows('egama NGESO_PreBuilt_OLTA_BMU') , filter ( 'egama NGESO_PreBuilt_OLTA_BMU', ('egama NGESO_PreBuilt_OLTA_BMU'[EVENT_START_DATETIME] <= Today() && 'egama NGESO_PreBuilt_OLTA_BMU'[EVENT_START_DATETIME] <=_max) && ('egama NGESO_PreBuilt_OLTA_BMU'[EVENT_END_DATETIME] >= Today() && 'egama NGESO_PreBuilt_OLTA_BMU'[EVENT_END_DATETIME] >=_max)))

[Anonymous]

@amitchandak  do you have any idea to write above expression in power bi