Invoke function to point a custom

[Anonymous]

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?

[amitchandak]

@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]

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]

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