Forum Discussion

StanTheMan's avatar
StanTheMan
Frequent Visitor
7 years ago
Solved

Dax Measure or Column for active datetimes this hour

Hi all, I'm experimenting with data from my own agenda using the Microsoft Exchange datastream.  This dataset contains multiple meetings with start and end dates by the hour, so what i would like...
Need Help
Tips and Tricks
  • Mariusz's avatar
    Mariusz
    7 years ago

    Hi StanTheMan 

    Please see the below.

    VAR dateTime = NOW()
VAR TimeStart = DATEVALUE(dateTime) + TIME(INT(TIMEVALUE(dateTime) * 24), 0, 0)
VAR TimeEnd = TimeStart + TIME(1, 0, 0)
RETURN 
IF(Calendar[startdate] => TimeStart && Calendar[startdate] < TimeEnd, "active", "not active")

    Regards,
    Mariusz

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity Champion
7 years ago

Hi StanTheMan 

Please see the below.

VAR dateTime = NOW()
VAR TimeStart = DATEVALUE(dateTime) + TIME(INT(TIMEVALUE(dateTime) * 24), 0, 0)
VAR TimeEnd = TimeStart + TIME(1, 0, 0)
RETURN 
IF(Calendar[startdate] => TimeStart && Calendar[startdate] < TimeEnd, "active", "not active")

Regards,
Mariusz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.