Forum Discussion
Deal Velocity Formula
Hi,
I'm trying to calculate the deal velocity which is the date of products won or lost - created date.
Currently, won date and lost date are in different columns which I have merged in Power Query.
The formula that I am using is:
However, when I put this into a matrix, the Deal Velocity value is being summed however I don't want it to sum:
Hi MissBI_21
You are using a Matrix visual. In Matrix, the Values fields should be aggregated values, so it is summed by default. You can also change the aggregation type like average, max, min... for it.
If you don't want to summarize it, you should use Table visual. Only Table accepts non-summarized values. In a table visual, you can right click on a column in Values well and select Don't summarize.
Hope it helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
2 Replies
Hi MissBI_21
You are using a Matrix visual. In Matrix, the Values fields should be aggregated values, so it is summed by default. You can also change the aggregation type like average, max, min... for it.
If you don't want to summarize it, you should use Table visual. Only Table accepts non-summarized values. In a table visual, you can right click on a column in Values well and select Don't summarize.
Hope it helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
