Forum Discussion
juliamacg_
3 years agoFrequent Visitor
Help building an incremental counting logic for a funnel visual
Hello, everyone! I'm trying to reach a formula that will sum up the number of approvals a paper has had until it reached its current step of analysis. The logic is rather simple: if, for example,...
HotChilli
Community Champion
3 years agoI think you have 2 options:
1. Work out a formula for a measure which calculates the implied steps from the above data. Might involve a hardcoded list of integers and a calculation to count the number of steps which are equal to or greater than each integer
or
2. Generate additional lines (which are implied in the data) for each maximum step, making the visual easier to think about. If this is done in Power Query, just add a custom column {1..[current step as an integer]} then Expand that column 'To Rows'. The column [current step as an integer] will have to be numeric and that can be calculated in a reasonably straightforward manner.