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 (rows) in a particular Month.
I ultimately want to be able to draw a line graph showing cumulative total number of Refs by Month.
I'm very new to Power BI and reporting so appologies in advance. Any help greatly appreciated.
@peterd 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.