November 29, 2017 at 12:00 am
Comments posted to this topic are about the item Stairway to DAX and Power BI - Level 12: Function / Iterator Function Pairs: The DAX CountA() and CountAX() Functions
November 29, 2017 at 2:11 am
This was removed by the editor as SPAM
November 30, 2017 at 12:15 pm
Hi,
I got this today and it looks like what I need, but when I went back to the beginning of the series I see that it was written 6 or so years ago and talks about SQL 2008R2.
Would there be much of an issue trying to follow along with new versions of SQL?
November 30, 2017 at 12:38 pm
Not really. As a matter of fact, you don't need SQL Server at all to do any of this - as long as the data is already in Excel. The only reason you may need SQL Server here is that I think the author gets his data from a SQL Server database... other than that, SQL Server is at best tangential to the whole thing.
March 25, 2020 at 1:27 pm
Re: 2020-03-25 (first published: 2017-11-29)
I received a link to this article from subscriptions@sqlservercentral.com via email this morning. The URLs provided for the .pbix demo file don't work for me (404 Page not found), in Chrome or in IE. I'm sure they were active when this article was originally published however, I was not seeking Power BI information at that time.
If there is a new/different URL from which this file can be downloaded, please advise. Thanks!
March 27, 2020 at 1:18 pm
If the column contains an expression that evaluates to an empty string, the COUNTAX function treats that result as non blank krogerfeedback.
June 17, 2020 at 10:52 am
Ever hear of a working download link?
June 29, 2020 at 4:19 pm
Download link(s) do not work. This content was just republished so the links should be checked. Otherwise, why re-issue the content?
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply