exact
2 TopicsTrying to make custom flag for in market and out of market time bwteen 2 tables
I am trying to make a simple comparison for time entries that looks as if the service location of a time entry is the same as the employee home branch, the time entry lives in its own table with the service location, and has a many to one relationship with cross directional filtering with the employee table which houses that persons home location. The dax I have currently is as follows: Out of Market Flag = IF(EXACT(Time_Entry[Service Location], 'Member'[Employee Location]), "In Market", "Out of Market") I have tried a few different variations but I cant seem to get the function to want to take the service location and employee location as inputs. I am sure what I am missing is simple but for the life of me I cant seem to find an example of this online to use for comparison. Thanks in advance!Solved913Views0likes6CommentsSearch In Different Order
I'm looking to have a search field that looks in a table where it searches the same words, but the words could be in a different order. In excel, it would be similar to the contains and contains filter instead of the exact filter. Example Description Field: Pen Blue Medium Bic In the search field if "blue pen" is entered I would like for this description to come up. It's only coming up if I type the words in the exact same order. Eg. "Pen blue", "blue medium" & "medium bic" Thanks in advance for your help! 🙂 Laurinda1.1KViews0likes2Comments