"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
Power BI Copilot, AI Instructions And DAX Query Templates
-
At the end of my last post I showed how, if you put the definition of a
measure in the AI Instructions of your Power BI semantic model, Copilot can
use it ...
2 days ago