SQL BI

My Experience - Troubleshooting SQL BI Stack

Browse by Tags

Tagged Content List
  • Blog Post: DAX: Using filter and summarize in same Query

    In this SQL Query we are grouping Sales by Year and Color plus adding a filter of 5000 select CalendarYear,color,sum(SalesAmount) from [DimProduct] join FactInternetSales on DimProduct.[ProductKey]=FactInternetSales.[ProductKey] join DimDate on dimdate.datekey=FactInternetSales.OrderDatekey Group by...
  • Blog Post: DAX-SUMMARIZE (ROLLUP)

      The following example adds roll-up rows to the Group-By columns of the SUMMARIZE function call. EVALUATE SUMMARIZE( 'Internet Sales', ROLLUP ('Date'[Calendar Year],Product[Product Category Name]), "Sales", ([Internet Total Sales]), "Tax",([Internet Total Tax Amount])) Red Box...
  • Blog Post: DAX – SUMMARIZE Statement

    SUMMARIZE function returns a summary table for the requested totals over a set of groups. Readers familiar with T-SQL SELECT statement, this is the equivalent of writing a query using the GROUP BY clause. Syntax - SUMMARIZE(<table>, <groupBy_columnName>[, <name>, <expression>...
Page 1 of 1 (3 items)