Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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]))
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
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |