DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries

Question

DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries

Frank A. Banin

SSCommitted

Points: 1619
More actions
April 30, 2020 at 12:00 am

#3742044

Comments posted to this topic are about the item DAX for SQL Folks: Part II - Translating SQL Queries to DAX Queries
Frank Banin
BI and Advanced Analytics Professional.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 999116 More actions · Answer 1

I will probably never need DAX but I have to say that I've book marked this incredible article for if I ever do. What a great thing you've done here... makes a great "Rosetta Stone" and makes for very quick learning by someone who already knows SQL (which, I suspect, would be the better part of the majority). Well done, good Sir, and thank you for taking the time to write and publish this article.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions

baexps_pr1 Newbie Points: 2 More actions · Answer 2

Hello Frank,

Really appreciate for this awesome article which makes direct mapping from SQL to DAX so that it can be learned quickly.

Good explanation indeed.

Best Regards