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 main...
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: