Forum Discussion
Solved
IF AND dax Formula
Hey, So I'm trying to add a column to filter the current month of the year. So far I've only been able to filter out the current month. deletePresentMonth = if(value(Date[Month]) = MONTH(toda...
Simply do an AND or &&, I usually use &&
State of Month = IF(YEAR(community[Date])=year(NOW()) && MONTH(community[Date]) = MONTH(NOW()),"Current Month","Previous Month")
hope this helps
Simply do an AND or &&, I usually use &&
State of Month = IF(YEAR(community[Date])=year(NOW()) && MONTH(community[Date]) = MONTH(NOW()),"Current Month","Previous Month")
hope this helps
