Forum Discussion

Stuznet's avatar
Stuznet
Helper V
7 years ago
Solved

Use measure as Filter

Hi, I’m struggling with a simple DAX. I created a measure to compare month and year between two dates. Measure = CALCULATE(Count[Column1]), FILTER(Table, MONTH([Date1]) = MONTH([Date2]) && YEAR([...
Need Help
Show and Tell
Tips and Tricks
  • parry2k's avatar
    parry2k
    7 years ago

    Stuznet add a column 

     

     New Column = 
IF( MONTH([Date1]) = MONTH([Date2]) && YEAR([Date1]) = YEAR([Date2]), "Matched", "Not Matched" )
parry2k's avatar
parry2k
Super User
7 years ago

Stuznet add a column 

 

 New Column = 
IF( MONTH([Date1]) = MONTH([Date2]) && YEAR([Date1]) = YEAR([Date2]), "Matched", "Not Matched" )
  • Stuznet's avatar
    Stuznet
    Helper V
    7 years ago
    Hi parry2k,

    I’ve tried that too. When I filtered to matched is giving me the one that is not matching too. When I filter to Not Matched is giving me blank
    • parry2k's avatar
      parry2k
      Super User
      7 years ago

      Stuznet would you mind sharing sample data and also if you can mention which records are showing wrong, will help.

       

       

      • Stuznet's avatar
        Stuznet
        Helper V
        7 years ago

        parry2k 

        I think I got it.


        This is what I did.

        First, I create a measure

        Measure  = COUNT([Product])

        Second, I create a calculated column

        Comparison = IF(MONTH([Received Date]) = MONTH([Date Submitted]) && YEAR([Received Date]) = YEAR([Date Submitted]),"Matched", "Not Matched")

         

        Thank you for your help :)