Forum Discussion
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...
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?
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: