value between two time range

[sukanya1990]

I want to get result between two time range.

Given the Test start time and test end time , the result of the required field should be displayed.

For eg - start time - 10:53:46 endtime - 12:53:35 . Result should be displayed between this time.

How to do this in PwerBI

[Anonymous]

@sukanya1990 

I am still a bit confuse with your expected result. So you want to show a column with rows of the time in between start time and end time? What is the interval? 

For now, you can try GENERATESERIES() or CALENDAR() to create a table.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
  

[amitchandak]

@sukanya1990 ,

https://community.powerbi.com/t5/Desktop/Calculating-day-time-difference/td-p/59601

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639#M389

try [starttime]-[endtime]