2013 doesn't have =filter() function. ANY alternate function?
I have Microsoft excel 365 in that filter function is available and i create a follow up sheet linked with database sheet where in database user will store data from the form. In database there is a column Follow up date. I want to show the all the data which will meet a date condition. I have done by using filter function but in 2013 it doesn't have filter function what function can i use to perform the same operation?
A connection was successfully established with the server, but then an error occurred during the pre
@Sergei Baklan I'm trying to use parameters in power query. I am now having a new error appear: DataSource.Error: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) Details: DataSourceKind=SQL DataSourcePath= (some server name) Message=A connection was successfully established with the server, but then an error occurred during the pre-login handshake. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.) ErrorCode=-2146232060 Number=10054 Class=20 I'm connecting to a Linux server, OS: 3.16.0-4-amd64. Typically, when connecting to it I go to get Data -> Odbc -> and then select the DSN and paste my SQL statement in the advanced options ... and it works perfectly Now I'm trying to use the following M code and it is giving me the error shown above Source = Sql.Database(Server, Database,.....) Thank you for the help
