Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Did anyone noticed with Count Function we can very well count even Date,Text
Documentation at one place says it count only number, other place mention about Text and Date too
I am able to Count any type of Column values with Count, how it is different from CountA?
has microsoft made some changes to language ?
Solved! Go to Solution.
Hi @NavinTyagi,
This is a recent enhancement to the COUNT function. Previously COUNT function doesn't count strings but just raise an error. We have since enhanced the function to count strings as well. You can refer to Remarks section in this article: COUNT Function (DAX).
The COUNT function counts rows that contain the following kinds of values:
Numbers
Dates
Strings
Regarding the COUNTA Function (DAX), it counts not just rows that contain numeric values, but also rows that contain nonblank values, including text, dates, and logical values.
The difference between those two functions are, COUNTA can count TRUE/FALSE column but COUNT still raises an error.
Best Regards,
Qiuyun Yu
Hi @NavinTyagi,
This is a recent enhancement to the COUNT function. Previously COUNT function doesn't count strings but just raise an error. We have since enhanced the function to count strings as well. You can refer to Remarks section in this article: COUNT Function (DAX).
The COUNT function counts rows that contain the following kinds of values:
Numbers
Dates
Strings
Regarding the COUNTA Function (DAX), it counts not just rows that contain numeric values, but also rows that contain nonblank values, including text, dates, and logical values.
The difference between those two functions are, COUNTA can count TRUE/FALSE column but COUNT still raises an error.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |