Forum Discussion
Count rows if between a certain time period in PowerQuery
Dear all, For below earlier asked question I've received the following DAX expression, which I'm very grateful for: Your Count = VAR timeFilterStart = 'Datasource'[Timestamp] - TIME(0,0,600)...
Hello, not sure if this needs to be another wuestion or not, but I pulling data as an admin on datasets. (when and what time they are refreshed). I am trying to count the number of datasets being refreshed every 30 min from 6AM to 10AM daily. I have a column for dataset name, date it was refreshed and start and end time for each one. Again, trying to determin number of items being refreshed.