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]>="...
Need Help
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