Forum Discussion

Muneeb91's avatar
Muneeb91
Regular Visitor
3 years ago
Solved

Using VAR and Return

Alarm & Efficiency % =     VAR __Calc1 = [alarm percentage]     VAR __Calc2 = [Efficiency %]     VAR __Calc3 = ([Efficiency %]+[alarm percentage])/2 RETURN         IF(ISBLANK(__Calc1), __Ca...
  • v-yinliw-msft's avatar
    v-yinliw-msft
    3 years ago

    Hi Muneeb91 ,

     

    You can try this method:

     

    Alarm & Efficiency % =

VAR __Calc1 = 'A&E'[AP]

VAR __Calc2 = 'A&E'[E]

VAR __Calc3 = ( 'A&E'[E] + 'A&E'[AP] ) / 2

RETURN

    SWITCH (

        TRUE (),

        ISBLANK ( __Calc1 ), __Calc2,

        ISBLANK ( __Calc2 ), __Calc1,

        NOT ( ISBLANK ( __Calc1 ) && ISBLANK ( __Calc2 ) ), __Calc3

    )

     

     

    Hope this helps you.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yinliw-msft's avatar
v-yinliw-msft
Community Support
3 years ago

Hi Muneeb91 ,

 

You can try this method:

 

Alarm & Efficiency % =

VAR __Calc1 = 'A&E'[AP]

VAR __Calc2 = 'A&E'[E]

VAR __Calc3 = ( 'A&E'[E] + 'A&E'[AP] ) / 2

RETURN

    SWITCH (

        TRUE (),

        ISBLANK ( __Calc1 ), __Calc2,

        ISBLANK ( __Calc2 ), __Calc1,

        NOT ( ISBLANK ( __Calc1 ) && ISBLANK ( __Calc2 ) ), __Calc3

    )

 

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.