Forum Discussion
Solved
Time range for time column
Hello! I'm working on a report where i want my graph to be dependent on a start and stop time from another table. In SQL my code would look something like this: SELECT [Value] ...
Thanks for replying!
With this COUNTX function, it only counts the rows, but i want the actual rows in a table to be returned 🙂
gustavjMC , This should have worked as a column in 'Temp' table
Range = Countx(FILTER('Temp', 'Temp'[logTime] > 'Wash'[startTime] AND 'Temp'[logTime] < 'Wash'[logTime]), 'Temp'[logTime])
refer video for example -https://www.youtube.com/watch?v=czNHt7UXIe8
Thanks for replying!
With this COUNTX function, it only counts the rows, but i want the actual rows in a table to be returned 🙂