Forum Discussion
Calculate difference from last update date
My sales data grouped by week is updated weekly, for confirmed orders and projected orders. The table includes [Update Date], [Sales Date], [Bill Type], [Total Qty] and [Total Rev]. I would like t...
hi smpa01
The problem is my data is not in SQL server but stored in SharePoint. I don't think I can use SQL script in this way, correct？
Anonymousokay. If this is a sharepoint location, I dont think you can utilize the SQL script on a sharepoint file. On a sharepoint list, you can utilize some limited sql scripting if you connect it through sharepoint rest api. However, if you can connect to this data source through ODBC connector, you can probably utilize the full sql script. If none of the above works this whole sql query can be converted into a fully working power query.