how to create a dax formula comparing a date in a table to a date you select from the calendar

[egiam]

Here is a dax formula that I put together and am stuck:

eg test 101 = calculate(DISTINCTCOUNT('DIM X'[X Id]), 'DIM X'[X_DC_SUBS_IND_YN] = "YES", 'DIM X'[Last App Submission Date]  ???

I am looking to count the distinct number of x id's that have a x_DC_SUBS_IND_YN = "YES" and I want the Last App Submission Date to not be in the month that I select. Explanation-- below you see, Month Year Name - Jan-2022, Feb-2022, Mar-2022, Apr-2022, May-2022.  I want to make sure that if I filter on Month Year Name = Jan-2022 that I"m getting a distinct count of the X id's, with X_DC_SUBS_IND_YN = "YES" but none of the ones that have a Last App Submission date within Jan-2022.  Hope this makes sense.

[v-kkf-msft]

Hi @egiam ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please try the measure.

eg test 101 = 
CALCULATE (
    DISTINCTCOUNT ( 'DIM X'[X Id] ),
    FILTER (
        ALL ( 'DIM X' ),
        'DIM X'[X_DC_SUBS_IND_YN] = "YES"
            && FORMAT ( 'DIM X'[Last App Submission Date], "MMM-YYYY" )
                <> MAX ( 'Calendar'[Month Year Name] )
    )
)

Best Regards,
Winniz

[Anonymous]

Hi

Not clear with colums name but try this

Measure=

var monthyear=SELECTEDVALUE(monthyear)

calculate(DISTINCTCOUNT(filter(dimx,'DIM X'[X_DC_SUBS_IND_YN] = "YES",'DIM X'[Last App Submission Date]&date(montyear)<>monthyear)))