Topic: Power BI

7 results
  • This advanced paper explains how SUMMARIZECOLUMNS works internally, providing insight into how to control its behavior in queries and measures following a list of best practices.  Read more

  • Writing DAX Queries

    Learn how to write DAX queries and how to manipulate tables in DAX measures and calculated columns.  Read more

  • Composite Models

    Learn the internals of Power BI semantic models created by using VertiPaq, DirectQuery over SQL, and DirectQuery for Power BI datasets and Analysis Services.  Read more

  • Learn how to use the new DAX window functions (INDEX, OFFSET, and WINDOW) to manipulate tables by sorting and partitioning data.  Read more

  • Learn how to use calculation groups and how they work internally. The whitepaper is a companion to the related SQLBI+ video course.  Read more