Power BI DAX: A Joint Measure to concatenate different measures with ampersand (&) Operator
The video shows one approach to concatenate different data type measures into one joint measure with power BI DAX operator ampersand (&) and report it in the Card Visual. The joint measure created by DAX operator ampersand (&) rather than the text function CONCATENATE as the function
accepts only two arguments and requires the creation of a series of calculations when we need to concatenate multiple items.On the contrary, the concatenation ampersand operator (&) provides us a simpler expression to join many data type items. To overcome the long decimals issue during the data type converting in the concatenation, the function FIXED is intoduced and applied in this video.
References:
CONCATENATE function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...
Text concatenation operator Ampersand (&):
https://learn.microsoft.com/en-us/dax...
FIXED function (DAX) - DAX | Microsoft Learn
https://learn.microsoft.com/en-us/dax...
For more info of my BI & Analytics, please refer to the following website links:
My BI & Analytics Website:
https://sites.google.com/view/mikegua...
My blog website :
https://mikeyu.lovestoblog.com/
