Forum Discussion
Daily Changing Measure
Hey everyone! I'm struggling with this problem it's been a while and I didn't get to any results. I also din't find any similar problem with a sollution, so I decide to ask for help here. I h...
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
So, use Power Query to your advantage.
Best
D