Forum Discussion

akheel312's avatar
akheel312
New Member
7 years ago
Solved

How to count same data and how to find time duration

I have two data sets

data set 1

MAC Address

RSSI

Date_Time (can replace with Time)

 

Dataset 2 (GPS Data)

latitude 

longitude

Time

 

for Data set 1, considering the Mac address as a person or individual, I need to find the Mac Addresses which are repeating and number of times it is repeating. 

 

For Dataset 1, many mac addresses are repeating at different time, I want to calculate the time difference that mac address is spotted for first time and the same mac address that is spotted at last time. 

 

Fot data set 1 and 2, I want to map the coordinates and check the landmarks on the route without zooming to check which area is busy and how many mac address are spotted at that time and at place.

 

I can provide data sets as well. if you are interested. 

Need Help
Tips and Tricks
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi akheel312 

    You may create the time difference measure and use 'count' for time as below.Link the two dataset tables with time column and choose 'count ' for  the mac address.

    time difference =
VAR first_time =
    CALCULATE (
        MIN ( 'Dataset 1'[Time] ),
        ALLEXCEPT ( 'Dataset 1', 'Dataset 1'[MAC Address] )
    )
VAR last_time =
    CALCULATE (
        MAX ( 'Dataset 1'[Time] ),
        ALLEXCEPT ( 'Dataset 1', 'Dataset 1'[MAC Address] )
    )
RETURN
    last_time - first_time

    Regards,

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi akheel312 

    You may create the time difference measure and use 'count' for time as below.Link the two dataset tables with time column and choose 'count ' for  the mac address.

    time difference =
VAR first_time =
    CALCULATE (
        MIN ( 'Dataset 1'[Time] ),
        ALLEXCEPT ( 'Dataset 1', 'Dataset 1'[MAC Address] )
    )
VAR last_time =
    CALCULATE (
        MAX ( 'Dataset 1'[Time] ),
        ALLEXCEPT ( 'Dataset 1', 'Dataset 1'[MAC Address] )
    )
RETURN
    last_time - first_time

    Regards,