Forum Discussion

RK9009's avatar
RK9009
Frequent Visitor
5 years ago
Solved

LIST DATE TIME/ PowerQuery / Dax

Greetings Everyone,    I am trying to solve a situation, not very successful at it until now. Can we get a list of date and time in power query or with dax.  below is the example for what I am try...
  • amitchandak's avatar
    amitchandak
    5 years ago

    RK9009 , Try a new column in Dax like

     

    new column =
    var _1 = date(year([enddate]),month([enddate]),day([enddate])) + time(5,0,0)
    return
    if( (_1 <=[enddate] && _1 >= [starttime]) && (_1-1 <=[enddate] && _1-1 >= [starttime]) ,"Yes", "No")

amitchandak's avatar
amitchandak
Super User
5 years ago

RK9009 , Try a new column in Dax like

 

new column =
var _1 = date(year([enddate]),month([enddate]),day([enddate])) + time(5,0,0)
return
if( (_1 <=[enddate] && _1 >= [starttime]) && (_1-1 <=[enddate] && _1-1 >= [starttime]) ,"Yes", "No")