Business Intelligence architect, Analysis Services Maestro, and author Bill Pearson exposes the DAX ISBLANK() function, and then provides some hands-on exposure to its use, particularly in combination with other DAX functions, in managing empty values underlying our PowerPivot model designs.
2022-04-04 (first published: 2013-05-09)
7,577 reads
A more detailed look at the DAX language and some of its more frequently used functions
2013-12-13 (first published: 2013-05-02)
11,117 reads
Business Intelligence architect and author Bill Pearson exposes the DAX BLANK() function, and then provides some hands-on exposure to its use in managing empty values underlying our PowerPivot model designs.
2022-04-04 (first published: 2013-03-18)
8,751 reads
Bill Pearson, Business Intelligence architect and author, exposes the DAX DISTINCT() function, and then provides some hands-on exposure to its use in generating distinct counts. Moreover, he further explores working with measures in the PivotTable in this, the third Level of our new Stairway to PowerPivot and DAX series.
2022-04-04 (first published: 2013-02-26)
10,665 reads
Bill Pearson, business intelligence architect and author, exposes the DAX COUNTROWS() and FILTER() functions, while generally exploring, comparing and contrasting the nature and operation of calculated columns and calculated measures, in the second Level of our Stairway to PowerPivot and DAX series.
2022-04-04 (first published: 2012-12-07)
21,817 reads
In this document I will attempt to talk you through writing your first very simple DAX queries. For the purpose of this document I will query the rather familiar Adventure Works Tabular Cube.
2013-12-13 (first published: 2012-09-25)
26,574 reads
Learning DAX is easy once you install the PowerPivot for Excel 2010 add-in and get practical exposure to using functions, operators and values in DAX formulas. Bill Pearson, business intelligence architect and author, kicks off another Stairway series designed to get you using DAX and PowerPivot quickly to provide actionable business intelligence in your own environment.
2022-04-04 (first published: 2011-12-21)
34,095 reads
Data Analysis Expressions (DAX) can be used in formulas or expressions to calculate and return information from data already in our Power BI models. This Stairway series serves as a progressive introduction to DAX within the context of Power BI, examining the functions, operators and values involved, and examining their operation in practice examples. As a part of introducing DAX functions and overall capabilities, the Levels of the series will also offer a wealth of practical exposure to Power BI features as a part of putting DAX to work in our data models and visualizations.
2022-04-04 (first published: 2011-08-09)
12,472 reads
Seems to me you should add another clause to this: UPDATE Ticketing SET TicketPriceExVat = (SELECT TicketPriceExVat FROM TempTicketing WHERE TempTicketing.EventID = Ticketing .EventID AND TicketPriceExVat IS NOT NULL)
2005-05-20
all error messages are in master.dbo.sysmessages i believe;so you'd select @err=@@error in your proc, then select description from master.dbo.sysmessages where error=@err if the severity was such that a run time error was raised, You could look up the error number in this table.
2005-05-18
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers