Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I have got problem to find solution of counting dates after given date.
Table1
Name | Option 1 | Option 2 | Option 3 |
Name 1 | 17/03/2023 | ||
Name 2 | 16/03/2023 | ||
Name 3 | |||
Name 4 | 13/03/2023 | ||
Name 5 | 18/02/2020 | ||
Name 6 | |||
Name 7 | 17/03/2023 | ||
Name 8 | 16/03/2023 | ||
Name 9 | 18/03/2020 | 13/03/2023 | |
Name 10 | |||
Name 11 | |||
Name 12 | |||
Name 13 | 03/12/2021 | ||
Name 14 | 01/01/2020 | ||
Name 15 | |||
Name 16 | |||
Name 17 | 16/03/2022 | ||
Name 18 | |||
Name 19 | |||
Name 20 | 03/12/2021 | ||
Name 21 | 03/12/2021 | ||
Name 22 | |||
Name 23 | |||
Name 24 | 16/03/2022 | ||
Name 25 | 16/03/2022 | ||
Name 26 | |||
Name 27 | |||
Name 28 |
I tried to use measure to count:
I tried to look diffrent solution: with countrow, filter but none of them worked.
Any ideas.
Regards,
MW
Solved! Go to Solution.
The date is not being recognised. Use DATE(...) instead of just writing 01/01/2023. The intellisense will help you
The date is not being recognised. Use DATE(...) instead of just writing 01/01/2023. The intellisense will help you
Hi,
I tired to make this more automated added this line:
Measure 1= CALCULATE(COUNT(Table1[Option 1]), Table1[Option 1]<> BLANK(), Table1[Option 1]>TODAY())
and this time it shows me some weird numbers.
Thanks that worked.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |