Forum Discussion
Calculated column not counting time properly
pardeepd84, Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Please find attached sample data, I have exported the data into excel as there is a lot of sensitive/client identifiable information in my dataset in Power Bi.
As mentioned above the formula is working for all other rows however if the time is recorded as 00:00 then it is not counting it, however it should be counting the number of times it appears in the dataset. As the ID, start date and start time all have data entered in the cells it should either return 1 or if all three columns have the exact same data in it it should return a number dependent on how many times it appears in the dataset. As you can see in the example below for ID 5432 has a start date and start time, as the data is the same and appears in the dataset twice it returns 2, however for ID 1234 it has a start date and start time so should return 1 or 2 if it appears in the dataset again.