I am in need of help here to calculate balance to average from MTD sales, for example I am sitting in September month and sales has happened till 8th Sep. My budget is x number so now I need to calculate balance to go average from budget. I am using following measure;
VAR LatestDate = MAX(SalesData[Date])
VAR EndDate = MAX(‘Calendar’[Date])
VAR DaysDifference = EndDate - LatestDate
IFERROR([BALANCE TO GO MTD]/DaysDifference,BLANK())
Only issue over here is that “SalesData” table has dates till 8th and “Calendar” table has dates till 30th Jun 2022 which I need to have.
Appreciate the assistance in advance.