Hello EDNA Forum! I’m currently working on something that has stumped me. We are running ‘progression analysis’ around how many customers are moving through our enrollment program each day. We have a simple-enough fact table with 1) customer, 2) date, 3) current status, 4) status index. I’m trying…

Hi @lfPBI , you may find the following post helpful in solving this. Contains both a Power Query and DAX solution for a similar problem. I’ve implemented the Power Query solution in the sample file below. [image] Calculate the number of days the quantity remained constant from a sel…

Counting how many customers have changed status

DAX DAX Calculations

sunip April 28, 2020, 11:37am 3

I noticed this after. Also, watch this video and see