Don't miss your chance to take exam DP-600 or DP-700 on us!
Request nowLearn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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?
| User | Count |
|---|---|
| 50 | |
| 40 | |
| 32 | |
| 14 | |
| 13 |
| User | Count |
|---|---|
| 87 | |
| 73 | |
| 37 | |
| 28 | |
| 26 |