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 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 :)