SQL BI

My Experience - Troubleshooting SQL BI Stack

Browse by Tags

Tagged Content List
  • 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>...
  • Blog Post: It takes 4 Clicks to Build a Model (Cube) in Denali Tabular Mode

    Click 1 – Create a Tabular Project Click 2 – Import Tables (Master / Facts) from DW Click 3 – Adding Measure As you can see I have added 2 Measures - Sum (TotalProductCost) Sum of TotalProductCost:=SUM([TotalProductCost]) Sum of SalesAmount:=SUM([SalesAmount]) Click 4 – Viewing Cube in Excel Click on...
Page 1 of 1 (3 items)