topic Re: Filter for a condition and populate one table value if true else populate another table value in DAX Commands and Tips

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

Krishna2285 — Tue, 18 Apr 2023 04:30:00 GMT

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?

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

Mahesh0016 — Tue, 18 Apr 2023 04:45:18 GMT

Krishna2285 can share demo dataset and Output you want.

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

v-jingzhang — Thu, 20 Apr 2023 06:39:17 GMT

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.