Forum Discussion
Remove filter off specific Column on Matrix
Hi everyone, I have a three column Matrix which is filtered by month. For one of them as supposed to having it calculate further by broken month I want to keep those values as YTD. How can I do this ...
Just wanted to provide a solution to my own post!
There is a built in Total YTD Function that I used. Works like a charm for anyone trying to do something similar
TOTALYTD(SUM(Column),DimDate[Year Month],ALL(DimDate),"10/31")
Just wanted to provide a solution to my own post!
There is a built in Total YTD Function that I used. Works like a charm for anyone trying to do something similar
TOTALYTD(SUM(Column),DimDate[Year Month],ALL(DimDate),"10/31")