Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Can you share sample data and sample output.
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.
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:
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
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
92 | |
83 | |
62 | |
62 | |
58 |
User | Count |
---|---|
157 | |
118 | |
103 | |
76 | |
66 |