Forum Discussion

je_s's avatar
je_s
New Member
4 years ago

Filter/Remove duplicates based on table criterias

Hello

 

I need to keep track of production KPI's (stop time) based on the certain criterias mentioned below.

 

Example 1: Exclude all stops occuring during the same time as meeting, break or maintenance events. 

Example 2: Exclude TC-stops when occuring (and have the same duration) as a position stop

 

 

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    My suggestion is you work on this using Power Query, as it will result a lot easier. However, should you want to pursue DAX, you can try creating a column and using an IF measure. It is not very clear what is it that differentiates the 2 examples, why is one "Actual stop" at [Position] = "TC_1" and the other at "Pos_2"? 

    • je_s's avatar
      je_s
      New Member
      4 years ago

      TC stands for Tact circuit if that makes sense. The tact circuit is always in status "stopped" when a position in status "stopped" but not the other way around. 

      I've have tried using DAX and IF measures but have really got the results I was hoping for. Any suggestions?  

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        It might be a DAX hell to work on it by using IFs, CALCULATE, LOOKUP etc etc. My suggestion is that you use Power Query/M to deal with this. There's plenty of tools, try going on Add Column and Conditional Column:

         

  • je_s's avatar
    je_s
    New Member
    3 years ago

    I'm not sure the Power Query-editor will do the trick in this case. Or do you have any suggestions? 

     

    The thing is.. I want to remove all "Stopped"-events when they occurs simultaneously as a meeting/break or maintenance break and those are on diffrent rows with the same time stamp.