Forum Discussion

GregB49's avatar
GregB49
Helper I
5 years ago
Solved

Intersection between two duration

Hi everyone,  I'm here for a new problem ! First a little sum-up.  I have 2 sensors linked to 2 devices. Each one send information about the state of the device. example :  As you can see,...
Need Help
  • GregB49's avatar
    GregB49
    5 years ago

    Hi Janey, 

    Sorry for my late reply. I tried to use you pbix file, and to be honest it didn't really work as it shoud. 🙂 
    I'm sure it's my fault, don't worry. Nethertheless, I succeded by doing something else. Here is the idea if someone needs it : 
    - I "un-pivoted" my columns so I have the devices on different columns.

    - I used (in PQ) the fill up option, from the top to the bottom. So the if there is a blank (like if a device give its state and not the other), it will take the last state declared. 
    - Now I have for each time, 2 declarations for the 2 devices. So it is way easier. Just have to filter my table with State device 1 ="On"&&State device 2="On". 

    It may not be the best solution, but for now, it is the best I have. 🙂 

    Anyway, many thanks to you Janey, for having helping me !
    Greg

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
5 years ago

Hi, GregB49 

 

Okay, your idea is definitely achievable, but I still have a  question. If you answer me, I can help you soon. For the duration of each date, is it within one day, or from the earliest time to this day?

 

Best Regards

Janey Guo

GregB49's avatar
GregB49
Helper I
5 years ago

Hi v-janeyg-msft ,
I hope I understand well your question, so I guess it is within one day.

Thank you for your help !
Greg