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 » PowePivot » Power BI   (RSS)
  • New function and the importance of variables in DAX #dax

    I recently wrote a few articles about a new function in DAX and the use of variables. For those of you using Power BI or Azure Analysis Services, you always have access to the latest version of the language. Well, in reality I see that new features appears in Power BI Desktop first, and shortly after in Azure Analysis Services. I’m also working ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on August 1, 2017
  • Avoid measure and column with the same name in #dax

    I recently wrote an article about duplicated names in DAX to highlight a possible case where you can have a measure with the same name of a column. This is not a good idea, mainly because the syntax to reference a measure and a column is identical, and this similarity is the root of a number of issues. It would be much better if the measure ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on May 2, 2017
  • Year-over-year comparison using the same number of days in #dax

    When you use the time intelligence functions in DAX, it is relatively easy to filter the same dates selection in the previous year by using the SAMEPERIODLASTYEAR or DATEADD functions. However, if you follow the best practices, it is likely that you have a full date table for the current year, which includes many days in the future. If you are in ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 24, 2017
  • Upcoming conference speeches and workshops #ssas #tabular #dax #powerpivot

    Between May and July I and Alberto will be speaker at several conferences, and I think it could be useful to write a single blog post with a recap:PASS Business Analytics Conference 2014 - May 7-9, 2014 - San Jose, CaliforniaQuerying in DAX (Marco Russo)DAX from the Field: Real-World Case Studies (Alberto Ferrari)Microsoft TechEd North ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on April 28, 2014
Privacy Statement