Forum Discussion

Stuznet's avatar
Stuznet
Icon for Helper V rankHelper 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" )
Stuznet's avatar
Stuznet
Icon for Helper V rankHelper 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
Icon for Super User rankSuper 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
    Icon for Helper V rankHelper 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 :)