Forum Discussion
Daily Changing Measure
It's not enough to capture TODAY's data. You have to capture the history. So, in other words, every day you have to grab what there is and store it somewhere, possibly in a database, or in a file. Jobs should have ID's, of course. With these, you'll be able to track them through time. But the requirement is that every day you have to have a NEW snapshot of the jobs and their statuses saved somewhere. Then you'll combine all the historical data into a fact table from which you'll then be able to calculate what you need.
Best
D
Anonymous
Exactly! Today I do it manualy in Excel. But that is exactly process de I want to "automatize" with power BI. As the responsible for the job changes it status from "open" to "Closed" instead of launch a new line, there is no history for status. I kinda need power bi to creat an "image" of the value, just like I do in Excel now.
- As I said, every day you have to automate extracts and put them in the same folder. The names of the files should have a well-defined scheme as well. And then PBI can easily do the rest since Power Query can read a folder full of files with THE SAME STRUCTURE and load them all at once into a fact/dimension table(s).
So, use Power Query to your advantage.
Best
D
