I’ve attached an excel file with a sample data set.

This excel has 3 columns:

**Lag days:** the number of days passing between when a lead enters the system and when they make a sale

**Count:** a count of leads for each number of lag days

**% of total:** % of total for the count column.

I’m trying to locate the earliest lag day in which the cumulative % of total is 80% or more. That is, 80% of leads fall into this range of lag days between 0 and X.

In the dataset example, scroll down to lag day 160, highlighted green. On this day, the cumulative % of total reaches 80%. **160 is the result I’m looking for in this example.**

I believe I need to first find a cumulative % of total as you move from 0 to higher lag days. Then isolate the earliest lag day on which that cumulative total reaches 80%. I’ve attached a pbix file with the base measures (count, cumulative total count, cumulative total % of total, etc.). Now I just need to figure out how to isolate day 160 as the result, which is the first day that the cumulative total is 80%.

Hope this makes sense! Thanks in advance.

Example Data.csv (5.6 KB)

Example Data PBIX.pbix (31.4 KB)