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)
    )

Thennarasu_R's avatar
Thennarasu_R
Responsive Resident
1 year ago

Hi RichOB 
Below mention calculation only for the  April Month Count .

Canada_Count = CALCULATE('Sheet1'[Canada], 'Sheet1'[Country] = "Canada"),AND(Date Colum>=01/04/2024,Date column<=30/04/2024)

Thanks,
Thennarasu R

If answered your questions mark accepeted a solution and give kudo !