=Calculate( [balancest], FILTER(ALL('Calender'[datein]), 'Calculate[datein] <= MAX ('Calender'[datein]) code example
Example: power bi in date range dax
DATESBETWEEN(<dates>, <start_date>, <end_date>)
DATESBETWEEN(<dates>, <start_date>, <end_date>)