Forum Discussion
13 Week Matrix overlapping 2 years
v-yuta-msft I apologize I don't have all that much experience so I have a few follow up questions. In the formula you've posted I need to include the actual table name from my data sets where I see "Table" as well as include exact field names such as Fiscal Year instead of year?
I was able to follow your instuctions however when I filter it removes every week not 1-3 from my matrix. Screenshot is below.
Anonymous,
v-yuta-msft I apologize I don't have all that much experience so I have a few follow up questions. In the formula you've posted I need to include the actual table name from my data sets where I see "Table" as well as include exact field names such as Fiscal Year instead of year?
I was able to follow your instuctions however when I filter it removes every week not 1-3 from my matrix. Screenshot is below.
Yes, the formula I have posted is based on the actual table. If the matrix contains columns from other dimensional tables, then the formula may not work. You should use expressions like IN VALUES(Dimensional_Table[Slicer_Column]) instead. Actually which kind of formula should be used is based off your spefic senario and data model.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.