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 t...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Can you share sample data and sample output.

  • 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:

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        HI Anonymous,

        Perhaps you can do unpivot on your source table value fields, then you can simply compare between different value attributes:

        Unpivot columns (Power Query) 
        Regards,

        Xiaoxin Sheng