lastdate is not showing for current month

[IAmCare]

I need to show monthly totals for the current fiscal year .

This is what i have and it works just fine but does not show the total for the current month.

O_Current = calculate(sum(Query1[SalesOrderCount]),LASTDATE('Edw DimDate (3)'[Date]))

I need all the previous months and the total thus far for the current month.  Please help

[IAmCare · Accepted solution]

I figured it out myself.  Thank you

O_Current = CALCULATE(SUM(OpenOrders[SalesOrderCount]),lastdate(DATESBETWEEN(OpenOrders[SnapshotDate],min('Edw DimDate (3)'[FiscalMonthStartDate]),Max('Edw DimDate (3)'[FiscalMonthEndDate]))))

[v-shex-msft]

Hi @IAmCare,

Can you please share some sample data to help us clarify your scenario?

Regards,

Xiaoxin Sheng