I am facing one issue while calculating one measure.
I have calculated one measure which is like Measure1 = Calculate(Sum(Table[Column1]), filter1, filter2,filter3) , And I have added date as filter on my report plane.So I am getting sum filtered by date. But I want other KPI which shows sum of the same column for previous year last date(Financial Year)(Measure2), So I calculted one measure for previous year last date which works perfect. But when I create measure to calculate sum for previous year last date it is giving me some error. Measure3 = Calculate(measure1, date = measure2)
For Measure3, you can define the previous year last date as a variable. If you have some other filters for the date, you can also add them into this variable. Then just do a sum calculation by filtering the table with the defined variable like following sample DAX formula.
VAR m2 =
MAX ( Table1[Date] ),
YEAR ( Table1[Date] )
= YEAR ( NOW () ) - 1
&& MONTH ( Table1[Date] ) = 9
CALCULATE ( SUM ( Table1[Sales] ), FILTER ( Table1, Table1[Date] = m2 ) )
If issue persist, could you please share your PBIX file through online file service like OneDrive, and provide the expected result for your visual?