calculate total between start date and last day of current month - DAX (power pivot)
Posted on 2016-09-08
I have a traditional sales entries table with balances, due dates etc.
I want to calculate the total balance due between a given start start (e.g 1900) and the last day of the current month.
I know I could use the dates between function like below, however I would need to alter the range every month.
How would I change the end date (bold) so that it always refers to the last day of the current month.