Hi! Yes, you can use the ROWNUMBER() function to do this. You can see some information in video 8.2 in this playlist th-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html&feature=shared I hope it helps!
Is there any possibility of converting SQL Query into DAX? I got a task to migrate SQL queries to DAX but Query Designer is unable to detect DAX and outputs syntax errors. Connection type - Microsoft SQL Server
Hi! You wouldn't write DAX to query a SQL Server database. You can write DAX to retrieve data from a SQL Server Analysis Services data model or a Power BI shared dataset learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets
fantastic tutorial - really well explained. Thank you so much!
You're very welcome, Alex! Thanks for watching and for taking the time to leave a comment!
Wonderful video. Thank you
You're welcome Vincent, thanks for your support!
Hello! Thank you. Could you tell me how can I make rownumbering within a group?
Hi! Yes, you can use the ROWNUMBER() function to do this. You can see some information in video 8.2 in this playlist th-cam.com/play/PLNIs-AWhQzcmEFHyxCRwA_gb29WOz5SJU.html&feature=shared
I hope it helps!
Is there any possibility of converting SQL Query into DAX?
I got a task to migrate SQL queries to DAX but Query Designer is unable to detect DAX and outputs syntax errors.
Connection type - Microsoft SQL Server
Hi! You wouldn't write DAX to query a SQL Server database. You can write DAX to retrieve data from a SQL Server Analysis Services data model or a Power BI shared dataset learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder-shared-datasets