Forum Discussion

weakneee's avatar
weakneee
Frequent Visitor
3 years ago
Solved

Return Same Value Using Divide

Hello!   Hope you're doing well. As the images below, I want to return the same value if the column "TipoMultiplicacao" is "EXTERNA" as an alternate result.    In a nutshell is: If "TipoMultiplic...
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

     

    CustoAula CC =
IF (
    ReferencialTreinamentos[TipoMultiplicacao] = "Interna",
    DIVIDE (
        ReferencialTreinamentos[Custo],
        ReferencialTreinamentos[NumeroInteriroHoras]
    ),
    ReferencialTreinamentos[Custo]
)

     

Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

Hi,

I am not sure if I understood your question correctly, but please check the below picture and the attached pbix file.

 

CustoAula CC =
IF (
    ReferencialTreinamentos[TipoMultiplicacao] = "Interna",
    DIVIDE (
        ReferencialTreinamentos[Custo],
        ReferencialTreinamentos[NumeroInteriroHoras]
    ),
    ReferencialTreinamentos[Custo]
)

 

  • weakneee's avatar
    weakneee
    Frequent Visitor
    3 years ago

    It worked perfectly! 

     

    Thank you so munch, Jihwan!