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 ...
  • FreemanZ's avatar
    FreemanZ
    3 years ago
    try this:
    Measure2 =
    CALCUALTE(
        Measure1,
        DateDim[Date] > = DATE(2022,1,1),
        DateDim[Date] < = DATE(2022,6,30)
    )
FreemanZ's avatar
FreemanZ
Super User
3 years ago
try this:
Measure2 =
CALCUALTE(
    Measure1,
    DateDim[Date] > = DATE(2022,1,1),
    DateDim[Date] < = DATE(2022,6,30)
)