topic Re: How to solve Overlapping Issues in a Activity Tracker Power Bi with Start Date and End Date?? in DAX Commands and Tips

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

Nisha_Innola — Tue, 20 Sep 2022 10:25:58 GMT

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??

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

Greg_Deckler — Tue, 20 Sep 2022 10:30:45 GMT

Nisha_Innola So like this? (1) Overlap - Microsoft Power BI Community

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

Nisha_Innola — Tue, 20 Sep 2022 12:50:07 GMT

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

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

Anonymous — Thu, 06 Oct 2022 08:56:29 GMT

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

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

Nisha_Innola — Thu, 06 Oct 2022 11:16:46 GMT

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??