DAX – “CONTAINSX” Revisited: What WAS the Match?
Last week’s post on “CONTAINSX” proved to be quite popular. In the comments, Sasha provided an alternate formula that used FILTER instead of SUMX
Month: June 2014
DAX – “CONTAINSX” – Finding if a value in table 1 has a matching value in table 2
These are a few of my favorite things… Perhaps the only thing that makes me happier than a new “X” function (I still badly want a CONCATENATEX) is “inventing” a new one (like we’ve seen with PRODUCTX).
“I Modified an Existing Table in Power Query and Now it Won’t Refresh”– A Fix
It’s the same old story, I mashed and twisted some data through Power Query, pulled it through Power Pivot, spent hours creating calculated columns and measures, made a really nice Pivot Table with conditional formatting and all the bells and whistles.