"using the MDX filter () function and the vba text functions you have plenty of search possibilities
filter (DimName.children, instr(DimName.currentmember.Properties("Name"),"MyValue")>0"
The full post is at:
http://www.developmentnow.com/g/112_2004_3_0_0_407650/MDX-equivalent-to-SQL-LIKE-operator.htm
Grouping And Filtering In Power BI Copilot AI Instructions
-
Continuing my series on Power BI Copilot AI Instructions (see also my
previous post which is the only other one so far), in this post I’d like to
show some...
5 hours ago