Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Invoke function to point a custom

Hi all,

I definited 5 data groups :

PI event = SWITCH(TRUE();

Totally[Week]>="19W49"&&Totally[Week]<="20W09";"PI19W49";

Totally[Week]>="20W10"&&Totally[Week]<="20W21";"PI20W10";

Totally[Week]>="20W22"&&Totally[Week]<="20W36";"PI20W22";

Totally[Week]>="20W37"&&Totally[Week]<="20W48";"PI20W37";

Totally[Week]>="20W49"&&Totally[Week]<="20W52";"PI20W49"

)

Then I want to compare the Totally[C12 PERCENTAGE] value between two PIXXX:

 

PI O PI = VAR __BASELINE_VALUE =

    CALCULATE(Totally[C12 PERCENTAGE];LASTNONBLANK(Totally[PI event];-1))

VAR __MEASURE_VALUE = Totally[C12 PERCENTAGE]

RETURN

FORMAT(

    DIVIDE( __MEASURE_VALUE-__BASELINE_VALUE; __BASELINE_VALUE);

"0.0%")

 But the result is not what I want, maybe the function LASTNONBLANK is incorrect, so can someone tell me which function I should invoke and how to make the result correctly?

Need Help

3 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , seem like Totally[PI event] is created as a column then there should be some filter use on this like

     

    CALCULATE(Totally[C12 PERCENTAGE];Totally[PI event]= LASTNONBLANK(Totally[PI event];-1))

     

    What do you want to filter? LASTNONBLANK will take row context

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes, the PI event is created as a column, and grouped by weeks. 

      There are 5 "PI event" in this column, and I want to analyze the data (C12 PERCENTAGE) in different period time.

      So could you tell me which function should I use?

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        Would you please try to use the following formula:

         

         

        CALCULATE(Totally[C12 PERCENTAGE];Totally[PI event]= LASTNONBLANK(ALL(Totally[PI event]);-1))

         

         

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

         

        Best Regards,

        Dedmon Dai