Forum Discussion

jinivthakkar's avatar
jinivthakkar
Frequent Visitor
3 years ago
Solved

Measure between two hardcoded dates

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

 

 

 

  • try this:
    Measure2 =
    CALCUALTE(
        Measure1,
        DateDim[Date] > = DATE(2022,1,1),
        DateDim[Date] < = DATE(2022,6,30)
    )

1 Reply

  • try this:
    Measure2 =
    CALCUALTE(
        Measure1,
        DateDim[Date] > = DATE(2022,1,1),
        DateDim[Date] < = DATE(2022,6,30)
    )