I've been trying to use allexcept , and failing,
I have a measure for Monthly average by year ;
AVERAGEX(VALUES('Calendar'[MMM-YYYY]),[Tunits])
Which Have then used in two version to get rolling average
andPlease Login or Register to view this content.
Rather than using CROSSJOIN ALL and VALUES, could I use ALLEXCPT instead? and if so how?Please Login or Register to view this content.
Richard
Bookmarks