Forum Discussion
Case sensitive text filter
Hi all. Working with Salesforce id data which, as some of you may know, distinguishes between users via case. For example, 001J000001Hs5Ss and 001J000001Hs5SS are two different users. This is the ...
If you want I can show you a Power Query function that calculates the case safe id.
For the DAX option you will need a custom visual like TextFilter to accept user input.
That sounds great - seeing the Power Query function would be very useful.
Not sure how the DAX option would work, could you share more detail?
Many thanks!