Desired output: depending on the Month you select in a filter/slicer, identify only the changes (Adds/Removals of the Identifiers) from the Selected Month vs Previous Month. For example, when selecting February in the filter/slicer, I want to show Identifier "E" (i.e. an Add, because "E" isn't present in January), and also "A" and "C" as the Removals (since they are present in January but not in February). Similarly, when I select March in a filter/slicer, I'd like to show "F" and "G" as the Adds (i.e. not present in February), and also "D" and "E" as the Removals (present in February, but not in March). Is there a way to accomplish this specifically with DAX? I'm able to get the results with anti joins in Power Query, but every time I do this monthly analysis I have to create 2 new filtered tables (filtered on the 2 months I need to analyze the changes on) and I don't want to do it this way. I want to keep 1 single 'append-all table' with all the months' data, and be able to identify the adds/removals based on the 2 months I select. I'm sort of looking for a 'dynamic filtering' option combined with anti joins within DAX.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
