StuznetHelper V7 years agoSolvedUse measure as FilterHi, 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([...Show Moreparry2k7 years agoStuznet add a column New Column = IF( MONTH([Date1]) = MONTH([Date2]) && YEAR([Date1]) = YEAR([Date2]), "Matched", "Not Matched" )
parry2k7 years agoStuznet add a column New Column = IF( MONTH([Date1]) = MONTH([Date2]) && YEAR([Date1]) = YEAR([Date2]), "Matched", "Not Matched" )
parry2k7 years agoStuznet add a column New Column = IF( MONTH([Date1]) = MONTH([Date2]) && YEAR([Date1]) = YEAR([Date2]), "Matched", "Not Matched" )
parry2kSuper User7 years agoStuznet add a column New Column = IF( MONTH([Date1]) = MONTH([Date2]) && YEAR([Date1]) = YEAR([Date2]), "Matched", "Not Matched" )
Related contentDynamic measure filteringFilter by Rank measureUsing measure as a filterMeasure not affected by filterDAX MEASURE TO FILTER
