peterdRegular Visitor7 years agoCumulative Count by Date Hi, For simplification purposes, I have a table with 2 columns. Ref (Text) and Date Built (DD/MM/YYYY). Ref is an order reference, non unique. I don't care what value Ref has just how many orders...Show More
parry2kSuper User7 years agopeterd add new measure as below cumulative total = caculate( countrows( table ), filter( all( table ), table[date] <= max( table[date] ) ) ) In expression, change table and column name as per your data model.
peterdRegular Visitor to parry2k7 years agoCheers parry2k I'll try this after Easter (or before if I'm being sad :-) )
Related contentYear to date cumulativeCumulative Count DAXCumulative Count by DateCumulative TotalCumulative count of ticket
