Filter for a condition and populate one table value if true else populate another table value

[Krishna2285]

check 3 = if (FILTER(Dim_Date,Month(Dim_Date[Date Only].[Date]) = Month(TODAY())),[check 2],[check])

here check 2 and check are built measures from 2 different tables
i am trying to get another value if the date is current month

can i get to resolve this issue?

[v-jingzhang · Accepted solution]

Hi @Krishna2285 

Do you want a measure? If so, in which visual do you want to put it in? Is there any other field or measure in the same visual? Assume that you want a measure and add it to a table visual which already has the Date column, you can try a measure like 

Measure = IF(MONTH(SELECTEDVALUE('Dim_Date'[Date]))=MONTH(TODAY()),[Measure 1],[Measure 2])

If you want to have a calculated column in the Dim_Date table, you can try DAX like 

Column = IF(MONTH('Dim_Date'[Date])=MONTH(TODAY()),"value 1","value 2")

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[Mahesh0016]

@Krishna2285  can share demo dataset and Output you want.