Forum Discussion
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([Date1]) = YEAR([Date2])))
Now I want to create a calculated column and use it as filter
Column = IF([Measure] >1, “March”, “ Not March”)
I can’t seems to get it to work.
Can some1 help?
Much appreciate!!
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([Date1]) = YEAR([Date2])))
Now I want to create a calculated column and use it as filter
Column = IF([Measure] >1, “March”, “ Not March”)
I can’t seems to get it to work.
Can some1 help?
Much appreciate!!
