Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
Solved

Need help adding a date range to a measure

Hi, I need to add a date range for my Canada customer count measure please. I currently have:   Measure 1: Customer_Count = Count('Sheet1'[Customer_ID]) Measure 2: Canada_Count = CALCULATE('Sheet...
Need Help
  • Muhammad_Ahmed's avatar
    Muhammad_Ahmed
    1 year ago

    Hi,
    you can try add one more filter inside calculate like this.
    Canada_Count =
    CALCULATE(
    COUNT('Sheet1'[Customer_ID]),
    'Sheet1'[Country] = "Canada",
    'Sheet1'[Date] >= DATE(2024, 4, 1),
    'Sheet1'[Date] <= DATE(2024, 4, 30)
    )

Muhammad_Ahmed's avatar
Muhammad_Ahmed
Helper I
1 year ago

Hi,
you can try add one more filter inside calculate like this.
Canada_Count =
CALCULATE(
COUNT('Sheet1'[Customer_ID]),
'Sheet1'[Country] = "Canada",
'Sheet1'[Date] >= DATE(2024, 4, 1),
'Sheet1'[Date] <= DATE(2024, 4, 30)
)