Dates filter when computing Value with SAMEPERIODLASTYEAR DAX

[Anonymous]

Hi PBI, prior to selecting filters the data in Matrix looks like this.. 

Sales $ LFY = CALCULATE(SUM(Sheet1[Sales$]),SAMEPERIODLASTYEAR(Sheet1[Month]))

When I select the 3 mths in the "Month FILTER", the table looks fine

When I select the "Quarter filter"...  the [Sales LFY] is missing

ASK - Is there a way where I can use either Month OR Quarter filters, without havig to create another New Measure = Sales $ LFY = CALCULATE(SUM(Sheet1[Sales$]),SAMEPERIODLASTYEAR(Sheet1[Fiscal Quarter]))

[Anonymous]

Hi @Anonymous,

Based on test, I found SAMEPERIODLASTYEAR function works not so smooth when filter on other fields.

When you choose items, you need to manually select the related previous records, then the formula will works.

Notice: When filter on other columns which calculate based on date column, it also works well.

In summary, the function seems work based on the hidden calendar table which generate by date files. If you try to filter with other columns not contains relationship to hidden calendar table, the function will be broken.

Regards,

Xiaoxin Sheng