Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I am an absolute newbie to M, and I am currently playing around with simple code snippets to understand the syntax of the language. Below is my code. I have 3 input variables (product price, qantity sold and product name) and I want to output all three of them (multiply product price with qantity and display the product name).
let
blue_shirt_price = 25,
blue_shirt_qty_sold = 10,
product_name = "Blue Shirt"
in
blue_shirt_price * blue_shirt_qty_sold & product_name
This is the error message I am getting:
An error occurred in the ‘’ query. Expression.Error: We cannot apply operator & to types Number and Text.
Details:
Operator=&
Left=250
Right=Blue Shirt
I couldn't figure out how to properly add my string variable to the IN block.
Any help is highly appreciated. Thanks!
Solved! Go to Solution.
let blue_shirt_price = 25, blue_shirt_qty_sold = 10, product_name = "Blue Shirt" in Text.From(blue_shirt_price * blue_shirt_qty_sold) & product_name
let blue_shirt_price = 25, blue_shirt_qty_sold = 10, product_name = "Blue Shirt" in Text.From(blue_shirt_price * blue_shirt_qty_sold) & product_name
I am an absolute newbie to M, and I am currently playing around with simple code snippets to understand the syntax of the language. Below is my code. I have 3 input variables (product price, qantity sold and product name) and I want to output all three of them (multiply product price with qantity and display the product name).
let
blue_shirt_price = 25,
blue_shirt_qty_sold = 10,
product_name = "Blue Shirt"
in
blue_shirt_price * blue_shirt_qty_sold & product_name
This is the error message I am getting:
An error occurred in the ‘’ query. Expression.Error: We cannot apply operator & to types Number and Text.
Details:
Operator=&
Left=250
Right=Blue Shirt
I couldn't figure out how to properly add my string variable to the IN block.
Any help is highly appreciated. Thanks!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
86 | |
81 | |
53 | |
37 | |
35 |