Forum Discussion
Dates filter when computing Value with SAMEPERIODLASTYEAR DAX
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...
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