Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Help with trend line data capture

Hello all. Im new here cause i hit the wall on something im trying to figure out.

I'm not so sure how to ask this clearly.

We are starting a project to make sure all windows endpoints are updated to the latest fearture pack (1903 for now). We have an endpoint management system with a SQL backend, so getting data is easy. Right now I just want to create a simple trend line that shows a daily count of the OS build numbers. so we can easily show/track progress being made in friendly graphs.

I'm guessing i need some DAX to help grab the count/date for each day and write it to another table that can be used for the line graph, correct? 

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      so, i have a main query that pulls in all the endpoint data. this table is updated every day and the data does change from day to day.

      what I would like to do is capture the countof OS Build Number and date, and i assume write it to a new table that tracks the date/build number/count - basically capturing the historical trend.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        i little more reference to what im looking for.

        We are also still migrating endpoints from win7 to win10, I tracked the progress via PBI as well. 

        but i was manually updating the table with counts and dates, so the graph showed progress. I just need a better/advance way to grab these trends

        example: