Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Translate Excel formula into PowerBI

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 ...
Need Help
  • rafaelmpsantos's avatar
    rafaelmpsantos
    7 years ago

    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.

rafaelmpsantos's avatar
rafaelmpsantos
Icon for Responsive Resident rankResponsive Resident
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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?