Forum Discussion
Store the data
Yes i was able to export to exel. Ok many thanks for your help but it is not a good solution form me
Your Q is too vague, you need to describe how you get your data to begin with.
Also, how many records are there each week. <30,000rows, you could data export directly from a matrix visual to a csv useing the [...] in the upper right of the visual.
Good luck.
I need to analize is the sales rep fill the pipe correctly.
EX: first week of june the pipe was 1Mil € for the Sales Mr. Brown. The pipe change continually because the sales add new opportunities into CRM. At the end of June the pipe will be 1.2 Mil€ but i dont remember the pipe the first week of june because the data are rereplaced with new updated.
I need to save\store the pipe of first week of june somewehre in order to compare both the pipe
...
Your Q is too vague, you need to describe how you get your data to begin with. ie where does the pipe data come from or better still what is the "Source" in the query editor. and how many records / week?
Is this your power bi .pbix or did someone else build it? Are you allowed to modify it?
If you are not permitted to modify it you will kinda be out of luck.
Without more technical detail this will probably drop off the bottom.
I agree with I_Like_Pi here. There are many ways to do this, but it all depends on how you're getting the data in the first place.
If you've only got current data from some sort of live connection, you'll need to export that data weekly to have a record of it saved somewhere, then you can compare current data to your saved past data.
If you've got all the past data already in your dataset, and you need help just returning data from the previous week, we can help with that.
If you're trying to compare what data was available in a previous week to the current data where new information has come in since, you'll need to add a new column to your data that specifies when an opportunity was added and sort by that.
