Using Longitude & latitude to create location based map.
I am working on crash data from Source Signal4. I have attached sample data picture for reference. So I am trying to create a report where I can locate multiple crashes between 500ft radius. I have longitude & latitude of each crash loaction. How do I create a map which will show me only location on a single roadway for e.g 5mile streach & show me hotspots where I have more that 5 incidents withing 500ft oof each other. I have used power bi for just few months & have understanding of how dax works but could'nt find any resolution for similar issue in community. This map helps me work on safety features for roadway strech.Year to Date Rolling Total by Location
Good Day, I am needing to a do a rolling total by year and location. If I filter it down to one location I get the correct results but having all locations selected in the column chart it gives wonky numbers. Can someone help me? I currently have this formula *** Better RT = VAR __Date = MAX('Assets'[Created_Date]) VAR __Table = FILTER(ALLSELECTED('Assets'),[Created_Date] <= __Date) RETURN SUMX(__Table,[Status Bit]) *** to get the rolling total and IF I have all locations filtered Filtering one location = correct results Start adding more locations and it will start getting all wonky.
