Forum Discussion

jhd's avatar
jhd
Icon for Helper I rankHelper I
8 years ago

Date filter having unexpected effect

I have the measure: GBPPRICE_END_FY-1=   VAR LASTSALE =    CALCULATE (        MAX ( 'Table1'[DATE_REC] ),        PREVIOUSYEAR ( 'Calendar'[Date], "3/31" ),        ALL ( Table1[SUPPLIER_GROUP...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Does this work?

 

=CALCULATE(MAX('Table1'[DATE_REC]),PREVIOUSYEAR('Calendar'[Date])

 

Drag years to the row/column area of the Table/Matrix visual.

 

If this does not work, then share the link from where i can download your PBI file.