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:
Thank you so much for your help.
Go to Solution.
Try below. If not working, then share the data type for timeOfCreation columns.
measure5 = COUNTX(FILTER('table5',[timeOfCreation]="01:00"),Table5[timeOfCreation])
ThanksAnkit JainDo Mark it as solution if the response resolved your problem. Do Kudo the response if it seems good and helpful.
View solution in original post
In case data is not in text format use either format or time to convert into another format
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
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!
Learn how to create your own user groups today!