I know we can use a filter in the where clause similar to how we would use it in T-SQL. But how can I put a where clause to filter out one specific value? For example, how can I edit the following query to display sales for the entire country except for
the state of IL? Thanks in advance.
SELECT Measure.Sales on 0,
Time.InvoiceDate on 1,
View Complete Post