Measure between two hardcoded dates

[jinivthakkar]

Hi All,

I have created a measure which is working fine, please see below measure.

Now I need to get measure between 2 specific dates which are 01-Jan-22 and 30-Jun-22. So I am not sure how I can modify existing measure without making changes to my data model/date dim table.

Measure1 =
CALCULATE (
    COUNTROWS ( MyTable ),
    FILTER (
        'MyTable',
        'MyTable'[col1] <> "myvalue"
            && MyTable[col2] = "myvalue"
            && MyTable[col3] <> BLANK ()
    ),
    USERELATIONSHIP ( MyTable[Date], DateDim[Date] )
)

I am confused, if I should you use formulaes like YTD, MTD or I should just add filters for dates and dates of which table (mytable or datedim) ?

Please guide.

TIA

[FreemanZ · Accepted solution]

try this:

Measure2 =

CALCUALTE(

    Measure1,

    DateDim[Date] > = DATE(2022,1,1),

    DateDim[Date] < = DATE(2022,6,30)

)