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

• Frank A. Banin

  SSCommitted

  Points: 1727

  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.

• Jeff Moden

  SSC Guru

  Points: 1004617

  More actions

  April 30, 2020 at 12:25 pm

  #3747646

  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)
  

• baexps_pr1

  Newbie

  Points: 2

  More actions

  May 28, 2021 at 4:28 pm

  #3889296

  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