Displaying Latest value in Matrix

[Anonymous]

Hi there,

Having trouble in finding the latest value-based on selected filters in slicers. 

When the Quarter and Month filters are selected on the slicer, the "Text" field has to display the latest record. 
We follow Fiscal Year and starting month is 1st of JULY. Fiscal year ends on 30 June. 
If Quarter Q1 & All months Selected => Last date should be the last record of the month September. 
If Quarter Q1, JUL & AUG is selected => Last date's value is latest record of the month August. 

and vice versa.

Issue is: When those filters are selected on the slicers, it brings all the values for the TEXT field and splits into two.

Sample PBIX file, excel source file and Image,

Expected result image 

Sample Excel File 

Sample PBIX 

Expected result: The latest value has to be displayed in the matrix on the TEXT field.

Thanks,
Praveen.

[rajulshah]

Hello @Anonymous,

I would suggest creating Dates dimension table as :

Calendar = CALENDARAUTO(06)

and create columns in this table as 'Table 3' and it's relationships too. It should work after doing these steps.