Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Dear PowerBI Community
First of all: Good luck for 2020!
I have the following question:
I want to create a measure that returns me the number of times the time 01:00 occurs in the column
For example, the measure for this table should return the number "4".
Think its not easy because its not an interger to check.
So the following expression does not work:
timeOfCreation |
01:00 |
02:00 |
03:00 |
01:00 |
02:00 |
01:00 |
03:00 |
01:00 |
Thank you so much for your help.
Cheers!
qwertzuiop
Solved! Go to Solution.
Hi @qwertzuiop
Try below. If not working, then share the data type for timeOfCreation columns.
measure5 = COUNTX(FILTER('table5',[timeOfCreation]="01:00"),Table5[timeOfCreation])
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
In case data is not in text format use either format or time to convert into another format
Like format(time,"HH:MM")
or time(01:00)
and then compare. Keep data type same on both sides.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi @qwertzuiop
Try below. If not working, then share the data type for timeOfCreation columns.
measure5 = COUNTX(FILTER('table5',[timeOfCreation]="01:00"),Table5[timeOfCreation])
Thanks
Ankit Jain
Do Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |