So I have a query that, if there is no data for today, won’t return Store and Product columns, it will be only the measures returned. Is it possible to always return fixed columns, even if they’re empty? I mean only columns, empty rows should be omitted. SELECT { [Measures].[Hourly Sales %] ,[Measures].[Pack Count Hourly] […]
Read More