Forum Discussion

Nisha_Innola's avatar
Nisha_Innola
Frequent Visitor
3 years ago

How to solve Overlapping Issues in a Activity Tracker Power Bi with Start Date and End Date??

Hi All,

I have created a PowerBi for tracking the Activities of my Team with Start TimeStamp and End TimeStamp. I have a normal graph with the Working hours calculated with EndTime - Start Time DAX. But what happens when the Activities overlap and I need a help in it with DAX formula? 

Can anyone Please help me with it??

4 Replies

    • Nisha_Innola's avatar
      Nisha_Innola
      Frequent Visitor
      3 years ago

      Hi Greg_Deckler

      Thnak you soo much for your reply...I have tired some of these solution already, but didnt work..Let me check with the remaining ones 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Nisha_Innola 

    Can you explain the the Activities overlap with a sample ? What is the result you want to get ? You can provide a screenshot or pbix file(remove sensitive info) to show your sample and result .

     

    Best Regards,
    Community Support Team _ Ailsa Tao

  • Nisha_Innola's avatar
    Nisha_Innola
    Frequent Visitor
    3 years ago

    Hi Anonymous .. Thank you for your reply. I havent dervied any visual for Overlapping Graph.I just had a normal graph with End_Time - Start_time(Bar graph). I need a visual overlapping graph with the fields available. Can you help me with it??