Help with trend line data capture

[Anonymous]

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? 

[amitchandak]

Can you share sample data and sample output.

[Anonymous]

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]

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:

[v-shex-msft]

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