Power Query: Text.Format() Example
The full course is available here: https://online.powerexcel.training
Free online course "Power Query Basics": https://online.powerexcel.training/trial
VK group: https://vk.com/sozhpq
In Excel, you can create text strings from static and variable parts using the & (ampersand) operator and the CONCATENATE(), CONCATENATE(), and CONCATENATE() functions.
In Power Query, this can be done in various ways, one of which is to use the Text.Format() function.
This video is a small excerpt from one of the lessons in Sergey Ozhiganov's online course on Power Query.