Forum Discussion
jinivthakkar
3 years agoFrequent Visitor
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
- FreemanZSuper Usertry this:Measure2 =CALCUALTE(Measure1,DateDim[Date] > = DATE(2022,1,1),DateDim[Date] < = DATE(2022,6,30))