SSMS/SSAS Coding MDX/DAX Query or SQL code for Connecting through SQL Server or Analysis Services

Power Query Data Setup
4

@ibesmond,

Yes, you would use same command. You just need to use where clause like below:

  1. single quote for string, if it is number, you will not use single quote
  2. IN clause for multiple values
  3. AND for and condition

WHERE [Document Type]=3 AND [Document Date] >= 10/1/2018 AND [Customer ID] IN(5565, 7783, 9968, 5573, .etc)

Please let me know if you get error while running it through ssms.

1 Like