topic Common date and time between rows in a report in DAX Commands and Tips

Common date and time between rows in a report

nelson777 — Mon, 02 May 2022 00:14:30 GMT

Hi there legends!

I have a dataset where each row is an alert resulting from a device that has lost connection to the VPN.

What I need:

1. know which days all devices had problems for a given customer.
example: client 01 has 8 devices and on 20/08/2021 all devices had generated alerts.

2. With the result of the first item, know if these devices all had problems at the same time.
example: amid the alerts all 8 devices had problems at 8:00 am.

I managed to resolve the first step in Excel but I'm struggling to think about how can I build these two measures in PBI.

This is what the data looks like:

and a visual example of my goal.

Re: Common date and time between rows in a report

lbendlin — Tue, 03 May 2022 00:35:36 GMT

Please provide sanitized sample data that fully covers your issue. If you paste the data into a table in your post or use one of the file services it will be easier to assist you. Avoid posting screenshots of your source data if possible.

Please show the expected outcome based on the sample data you provided. Screenshots of the expected outcome are ok.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Common date and time between rows in a report

nelson777 — Tue, 03 May 2022 01:09:01 GMT

Hi, lbendlin thanks for commenting and trying to help. Got some help from a senior PBI dev last night and the problem is now sorted.