Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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])
Customer_ID | Country | Date |
1 | Canada | 01/04/2024 |
2 | Canada | 02/04/2024 |
3 | Canada | 04/05/2024 |
4 | USA | 01/04/2024 |
5 | USA | 08/05/2024 |
6 | UK | 03/04/2024 |
7 | UK | 05/05/2024 |
8 | UK | 01/06/2024 |
9 | UK | 06/06/2024 |
10 | UK | 10/06/2024 |
Thanks
Solved! Go to Solution.
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)
)
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 !
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)
)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
108 | |
108 | |
108 | |
90 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |