Tag: EXCEPT Function

How To Compare Two Lists Of Calculated Data Virtually – An Advanced DAX Technique

How To Compare Two Lists Of Calculated Data Virtually - Advanced DAX Technique

When working with calculated data, comparing different data sets will sometimes be necessary. I’m going to show you how to do that by combining different table functions. The INTERSECT function is the best thing to use in cases like these. Some may also say that EXCEPT is just as useful in comparing calculated data. But

Continue reading