Quiz on Text Functions in Power BI DAX

Which function joins two text strings into one in DAX?

What is the correct syntax for CONCATENATE?

Which operator can be used instead of CONCATENATE?

What does LEFT(“Power BI”, 5) return?

Which function returns the last N characters from a text string?

What will LEN(“Power BI”) return?

Which function extracts characters from the middle of a string?

What will MID(“Data Analysis”, 6, 8) return?

Which function is best for finding the number of characters in a text?

How do you join “FirstName” and “LastName” with a space in between using DAX?

Which function would you use to remove unwanted spaces from the beginning and end of a text string?

If you want to replace part of a text string, which function is used?

What is the difference between REPLACE and SUBSTITUTE?

Which function would you use to find the position of a substring in a text?

What will LEN(TRIM(” Power BI “)) return?