Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello!
I have sales pipeline data and would like to consolidate the net changes (flow) in pipeline by month. Included some sample data but the current file as columns for the Pipeline Created Data (+) and Pipeline Close Date (-).
Null / blank close date means deal is still open.
Thank you in advance!
Hi,
The technique described in this article will split each ID into as many rows as there are months between the start and end. This will get your started.
Appreciate the help. I went about it a different way for now. I created a seperate summarized table for each date column above then created relationship on the dates. The seperate tables had the Amount sums by date. With a few other measures, I found the running totals and determined when quarter end is. Ultimately I want my stakholders to understand the movements from QoQ, I haven't quite gotten to the net changes but I'm not confident my method will work, let's see...
User | Count |
---|---|
97 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |