Report with nested select in sql view

[Anonymous]

I want to create a Power BI report based on a sql view with nested SQL select queries.
In this report I have two slicers for selecting datetime( from datetime1 to datetime2 and it has this fomat: '2023-04-09 08:20:30'.
these two values selected from slicers in report would be passed to SQL view to return a table with different values(within these two datetimes from slicers).
Here is a part of sql view as example.

Or is there a better way than SQL view to create report for this scenario?

[lbendlin]

Chris Webb's BI Blog: Handling Multi-select In Power BI Dynamic M Parameters (crossjoin.co.uk)