The DAX ENDSWITHX Function Equivalent
I remembered the excellent articles written by Rob Collie at powerpivotpro.com on the CONTAINSX function equivalent. I decided that it was time to extend this solution to search at the end of a string. In particular, I started to look at my bank statements and I had a need to filter all payments that were a fixed monthly payment. So, Rob's formula shown below worked great for this:
Read more...