THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » DAX » Power BI   (RSS)
Showing page 1 of 2 (14 total posts)
  • Free Introducing Power BI eBook and new DAX recorded video course #powerbi #dax

    Microsoft Press released a free eBook you can already download, Introducing Microsoft Power BI, which I and Alberto Ferrari wrote in the last few months. Please note it is a very introductive book, don’t expect an inside-out. As we wrote in the introduction: We wanted to write an introduction to Power BI that covers the basics of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on June 16, 2016
  • How to fix #dax time intelligence functions in #powerbi when date table uses a surrogate key

    I wrote an article about Time Intelligence in Power BI Desktop to explain how to fix measures using DAX functions for time intelligence when you have a data model where the relationship uses surrogate keys. THe short description is that all the time intelligence functions in DAX makes two assumptions: you have a ''full'' date table (all days ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2016
  • GROUPBY vs SUMMARIZE in #dax #powerbi #powerpivot

    If you are using Power BI Desktop or Power Pivot in Excel 2016, you should learn when and how you can use GROUPBY instead of SUMMARIZE. The SUMMARIZE function is very powerful and internally very complex, so it’s easy to find scenarios where you get unexpected results or you have performance issues. The new GROUPBY function (also available in SSAS ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 15, 2016
  • Conferences and Training in Australia Feb/Mar 2016 #dax #sqlsaturday

    In a couple of weeks, I will move to Australia for 3 weeks, visiting Melbourne and Sydney for a number of events and training. This is the list of topics in public events you can attend (with link to registration pages – remember that SQL Saturday conferences are free events, but you still have to register first!): UPDATE 2016-02-08 - added a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 31, 2016
  • Challenge your #dax skills with DAX Puzzle #powerbi #powerpivot

    Last week we launched a new page in SQLBI website: DAX Puzzle (you can also use www.daxpuzzle.com). The idea is very simple: we describe a scenario, we ask to solve a problem in that scenario and we might provide some hint to help you finding the solution. You can download a sample file (in Power BI Desktop, which is freely available to anyone – ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 21, 2015
  • The Definitive Guide to DAX is now available! #dax #powerpivot #powerbi #ssas #tabular

    I am so happy to announce that The Definitive Guide to DAX is finally available! I and Alberto Ferrari spent one year writing this book, and several years collecting the knowledge necessary to do that. The complete title is The Definitive Guide to DAX: Business intelligence with Microsoft Excel, SQL Server Analysis Services, and Power BI. You can ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 20, 2015
  • Don’t ignore the Context Transition in #dax

    Almost 3 years ago I wrote an article with the rules for DAX code formatting. If you quickly look at the article, you might think that it is all about readability of the code, and this is fundamentally true. But there two rules that have a particular importance for performance, too: Never use table names for measures Always use table names ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 22, 2015
  • Back to the basic: #dax primers for new #powerbi users

    The growing adoption of Power BI Desktop is gathering new users of the DAX language. At the same time, there are a few new features, such as bidirectional filter propagation, that introduce new concepts to existing knowledge. For this reason, in the last weeks we published two articles describing important basic concepts and clarifying the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 7, 2015
  • Power BI Desktop & Excel

    The August 2015 update of Power BI Desktop added two important features for existing Excel and Analysis Services users:Import Excel Power BI artifacts (Data Model, Queries, Power View) into a new Power BI Desktop fileLive Analysis Services Connections: Ability to change the database from Edit Queries dialogIn case you didn't try it before, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 31, 2015
  • DAX Formatter now supports Power BI Desktop and Excel 2016 #dax #powerbi

    If you use DAX, you should try DAX Formatter. Now it supports all the new functions introduced in Power BI Desktop and in Excel 2016. There are more than 70 new functions, even if half of them corresponds to Excel functions with the same name (see the second group). DAX Formatter also supports the variable syntax available in the new DAX. These ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 18, 2015
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement