Forum Discussion
Unique timeline from the overlapping time stamp
Hi, Anonymous
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
Table:
You may create a measure as below.
Result Measure =
SUMX(
SUMMARIZE(
'Table',
'Table'[Employee],
"Result",
CALCULATE(
SUM('Table'[Difference]),
FILTER(
'Table',
MONTH([Start Time])=2&&
DAY([Start Time])=4
)
)
),
[Result]
)
Result:
Or you can create the following calculated table.
Table 2 =
SUMMARIZE(
'Table',
'Table'[Employee],
"Result",
CALCULATE(
SUM('Table'[Difference]),
FILTER(
'Table',
MONTH([Start Time])=2&&
DAY([Start Time])=4
)
)
)
Result:
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Allan,
Thanks for the above solution, however it is not creating a unique timeline from the overlapping timestamp.
If you look at the table, the actual "downtime" for resource 1 on 4th February across four instances is only 5 minutes (as all the time stamp for resource 1 on 4th Feb is repeating between 3.35 pm and 3.40 pm, however, the result is showing 20 minutes which is misleading for the manager as they are coming in the dashboard to identify the "Lost Productivity" due to application outage. Actual DowntimeResult Measure
- v-alq-msft5 years ago
Community Support
Hi, Anonymous
I am sorry for the late reply. Could you show us what the expected result is like?
Best Regards
Allan