Measure between two hardcoded dates

jinivthakkar — Mon, 05 Dec 2022 09:24:34 GMT

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

Re: Measure between two hardcoded dates

FreemanZ — Mon, 05 Dec 2022 09:27:48 GMT

try this:

Measure2 =

CALCUALTE(

Measure1,

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

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

)

topic Re: Measure between two hardcoded dates in DAX Commands and Tips

Measure between two hardcoded dates

Re: Measure between two hardcoded dates