Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson introduces the DAX DATEADD() function, discussing its syntax, uses and operation. He then provides hands-on exposure to DATEADD(), focusing largely upon a popular use in creating prior-period values at multiple Date hierarchy levels.
2022-04-05 (first published: 2021-06-04)
976 reads
2020-03-27 (first published: 2018-08-21)
4,202 reads
Business Intelligence Architect, Analysis Services Maestro, eight-year Microsoft Data Platform MVP and author Bill Pearson introduces the DAX CountA() and CountAX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to CountA() and CountAX(), in counting non-empty cells in a column, and in counting nonblank results when evaluating the result of an expression over a table, respectively.
2022-04-04 (first published: 2017-11-29)
4,697 reads
Using R with Power BI, SSRS or RTVS for easier data visualization
2019-02-15 (first published: 2017-01-24)
4,015 reads
Continuing his examination of the evolving DAX “Function / Iterator Pairs,” Business Intelligence Architect, Analysis Services Maestro, Microsoft Data Platform MVP and author Bill Pearson introduces the DAX Concatenate() and ConcatenateX() functions, discussing the syntax, uses and operation of each. He then provides hands-on exposure to Concatenate() and ConcatenateX(), in joining two text strings into a single text string, and in returning the concatenation of an expression evaluated for each row in a table, respectively.
2022-04-04 (first published: 2016-09-21)
5,124 reads
Make sure that the windows firewall on the laptop isn't blocking your PDS'a access.Peter
2005-04-15
1 reads
It's not a table : run this in the master table Select objectproperty(object_id('sysperfinfo'), 'TableIsFake') It will return 1. This means than when you query that table, Sql server meterializes it so that the query can execute, but this information is never actually kept on the hd like a real table. checks BOLS : objectproperty::TableIsFake
2005-03-02
At the risk of being accused of being facetious, here are the differences between C# and VB.NET:- C# uses { and } to delimit blocks, whereas VB.NET generally uses new lines and tokens that are English wordseg if (condition) { true-block } else { false-block }versusIf condition Then true-block Else false-block End If- […]
2004-12-16
Oops, forget it. Reread it that you want it on both columns. Sorry.
2004-11-12
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
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