Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Recently moved from Qlik to Power BI and very new to using DAX
What would be the euqivalent to the Wildmatch function (please refer to image)
- basically what i have to do is combining several values(usually its just one) and then renaming them
If there would be a better solution i am happy to learn
Best regards
Solved! Go to Solution.
Power VI has search and find in Dax
https://docs.microsoft.com/en-us/dax/search-function-dax
https://docs.microsoft.com/en-us/dax/find-function-dax
For multiple filter use switch
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Hi, @baneworth
Based on your description, I'd like to suggest you use FIND(), SEARCH(), CONTAINSSTRING(), CONTAINSSTRINGEXACT().
Here is the functions for text.
1. Text connection functions :
CONCATENATE(<text1>, <text2>)
CONCATENATEX(<table>, <expression>, [delimiter])
COMBINEVALUES(<delimiter>, <expression>, <expression>[, <expression>]…)
DISTINCT(SELECTCOLUMNS(DimDate, "Month", COMBINEVALUES(",", [MonthName], [CalendarYear])))
2. Text search functions :
FIND(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
SEARCH(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
CONTAINSSTRING(<within_text>, <find_text>)
CONTAINSSTRINGEXACT(<within_text>, <find_text>)
3. Formatting text functions :
FIXED(<number>, <decimals>, <no_commas>)
FORMAT(<value>, <format_string>)
4. Intercepting text functions :
LEFT(<text>, <num_chars>)
RIGHT(<text>, <num_chars>)
MID(<text>, <start_num>, <num_chars>)
5. Replace text :
REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)
SUBSTITUTE(<text>, <old_text>, <new_text>, <instance_num>)
For further information, please refer to the official document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @baneworth
Based on your description, I'd like to suggest you use FIND(), SEARCH(), CONTAINSSTRING(), CONTAINSSTRINGEXACT().
Here is the functions for text.
1. Text connection functions :
CONCATENATE(<text1>, <text2>)
CONCATENATEX(<table>, <expression>, [delimiter])
COMBINEVALUES(<delimiter>, <expression>, <expression>[, <expression>]…)
DISTINCT(SELECTCOLUMNS(DimDate, "Month", COMBINEVALUES(",", [MonthName], [CalendarYear])))
2. Text search functions :
FIND(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
SEARCH(<find_text>, <within_text>[, [<start_num>][, <NotFoundValue>]])
CONTAINSSTRING(<within_text>, <find_text>)
CONTAINSSTRINGEXACT(<within_text>, <find_text>)
3. Formatting text functions :
FIXED(<number>, <decimals>, <no_commas>)
FORMAT(<value>, <format_string>)
4. Intercepting text functions :
LEFT(<text>, <num_chars>)
RIGHT(<text>, <num_chars>)
MID(<text>, <start_num>, <num_chars>)
5. Replace text :
REPLACE(<old_text>, <start_num>, <num_chars>, <new_text>)
SUBSTITUTE(<text>, <old_text>, <new_text>, <instance_num>)
For further information, please refer to the official document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Power VI has search and find in Dax
https://docs.microsoft.com/en-us/dax/search-function-dax
https://docs.microsoft.com/en-us/dax/find-function-dax
For multiple filter use switch
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Connect on Linkedin
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
95 | |
86 | |
76 | |
64 |
User | Count |
---|---|
138 | |
113 | |
107 | |
98 | |
92 |