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 3 (25 total posts)
  • 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
  • Unexpected side effects of table filters in #dax

    One of the side effects that you might not expect from a table filter in a CALCULATE statement is the removal of an existing filter. In reality, this is a condition that happens when you write an explicit CALCULATE in a row context, because the table filter overrides the context transition in case you filter the same table that generated the ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 21, 2017
  • New syntax in DAX: IN operator, table and row constructors #dax #powerbi

    I recently wrote an article to described in more details the syntax of the IN operator in DAX, which is available in Power BI and in the CTP of the next release of Analysis Services. Jeffrey Wang wrote a blog post about the IN operator a few months ago, so I waited some time to include more details about how it internally works ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on March 7, 2017
  • Mark as Date table in Power BI #dax #powerbi

    One year ago I wrote an article describing how the time intelligence DAX functions work in Power BI (I just updated the article including the example described below). In a recent event in Sydney I observed a strange (or at least unexpected) behavior of Power BI during a demo, and I think it is interesting to share a few considerations ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 21, 2017
  • Using SUMMARIZECOLUMNS instead of SUMMARIZE in #dax #powerbi #ssas #tabular

    One of the latest addition to DAX has been the ability to apply an external filter context to SUMMARIZECOLUMNS, which makes this function a perfect replacement for SUMMARIZE in DAX. In The Definitive Guide to DAX I introduced such a function, but at the time of writing it was used only by Power BI and it wasn’t possible to include it in a measure, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on February 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
  • VertiPaq Analyzer 1.7: a fundamental tool for #powerbi #powerpivot #ssas #tabular diagnostics and documentation

    If you work with Power Pivot, Power BI, or Analysis Services Tabular, you probably already know VertiPaq Analyzer. If you never used it, with the new release 1.7 you have another couple of very good reason to try it. VertiPaq Analyzer is a Power Pivot workbook that extracts information from data management views (DMVs) of a Tabular model. It can ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 16, 2017
  • Santa Claus brings presents to #dax, #powerbi, and #ssas #tabular users

    If you think that the end of the year would have been a quiet time because the Power BI team will skip their monthly release (but are we sure?), you might be reassured (or disappointed depending on your perspective) looking at the news I have in this blog post. SSAS Tabular vNext CTP 1.1 In 2017 Microsoft will release a new version of ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 21, 2016
  • Format measures as dates in Power BI #dax #powerbi

    If you want to format a measure as date in Power BI, you need an expression returning a date/time data type. This is different from what you can do in Power Pivot and in SSAS Tabular, where you can format any numeric expression using a date and/or time format, and the conversion is implicitly done to perform such a visualization. The problem ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on December 6, 2016
  • BLANK and Boolean functions like IF in #dax

    A recent change in the DAX language transformed the behavior of IF statement, so that it should not return BLANK but only TRUE/FALSE if the results should be logical expressions. In that case, the BLANK is transformed in a FALSE condition. For example, consider that the result of the following expression is FALSE and not BLANK: IF ( 1 = 1, ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on September 14, 2016
1 2 3 Next >
Privacy Statement