Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello folks!
I want to convert the excel formula of the file attached into Power BI.
I tried with the following expression but didn't work out (it returned me "Expressions that yield variant data-type cannot be used to define calculated columns."):
Ct. Converted TEST = IF ( SALES[Ct. Pietra Principale Unitaria - Copy] < 1; SALES[Ct. Pietra Principale Unitaria - Copy]; IF ( SALES[Ct. Pietra Principale Unitaria - Copy]> 9000; LEFT ( SALES[Ct. Pietra Principale Unitaria - Copy]; 1 ) & "," & MID ( SALES[Ct. Pietra Principale Unitaria - Copy]; 2; 5 ) ) )
Just to be clear i need both formulas of the green columns into Power BI. The second one is an "approximate vlookup".
Thanks to all.
Cheers,
AS
Solved! Go to Solution.
Try it
Ct. Converted TESt =
Var ctpietraprincipale = VALUE(SALES[Ct. Pietra Principale Unitaria])
var secondaespressione = VALUE(LEFT(VALUE(ctpietraprincipale);1) & "," & MID(VALUE(ctpietraprincipale);3;5))
return
if (
ctpietraprincipale<1;
ctpietraprincipale;
if( ctpietraprincipale>9000;
secondaespressione;0
)
)
If it solve your issue mark as solved, and please give me your positive feedback... bye.
Try it
Ct. Converted TESt =
Var ctpietraprincipale = VALUE(SALES[Ct. Pietra Principale Unitaria])
var secondaespressione = VALUE(LEFT(VALUE(ctpietraprincipale);1) & "," & MID(VALUE(ctpietraprincipale);3;5))
return
if (
ctpietraprincipale<1;
ctpietraprincipale;
if( ctpietraprincipale>9000;
secondaespressione;0
)
)
If it solve your issue mark as solved, and please give me your positive feedback... bye.
Hello!
It did workout, however you had to substitute "," with "."
Anyhow very happy it works now. Any idea on how to get the second green column?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |