Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
J_4923
Frequent Visitor

SQL to DAX

Hi,

 

I would like to create a calculated table but don't know how to translate below to DAX?

 

/****** Script for SelectTopNRows command from SSMS  ******/
select distinct * from (

SELECT distinct originCountry as country, originArea as area, OriginRegion as region,seaair as product, customerName as customer
  FROM tmp where ETDYear = 2017

  union all

 
SELECT distinct DestinationCountry as country, DestinationArea as area, DestinationRegion as region,seaair as product, customerName as customer
  FROM tmp where ETDYear = 2017

  union all

  SELECT distinct FreightPayerCountry as country, FreightPayerArea as area, FreightPayerRegion as region,seaair as product, customerName as customer
  FROM tmp where ETDYear = 2017 
  
    union all

  SELECT distinct CRMOwnerCountry as country, CRMOwnerArea as area, CRMOwnerRegion as region, customerName as customer
  FROM tmp where ETD = '2017-03-12' and BLNumber in ('0001748TPA','AAR0029009')

 
  ) as GEOCustomer where area != 'AGENT' order by customer

1 ACCEPTED SOLUTION
v-caliao-msft
Microsoft Employee
Microsoft Employee

@J_4923,

 

You could use this query in Power BI desktop directly.
Capture.PNG

 

Besides, there are big difference between T-SQL query and DAX query. You'd better to learn DAX basics before you can convert T-SQL to DAX, here are some useful links for you reference.
https://support.office.com/en-us/article/QuickStart-Learn-DAX-Basics-in-30-Minutes-51744643-c2a5-436...
https://www.sqlbi.com/topics/from-sql-to-dax/

 

Regards,

Charlie Liao
 

View solution in original post

2 REPLIES 2
v-caliao-msft
Microsoft Employee
Microsoft Employee

@J_4923,

 

You could use this query in Power BI desktop directly.
Capture.PNG

 

Besides, there are big difference between T-SQL query and DAX query. You'd better to learn DAX basics before you can convert T-SQL to DAX, here are some useful links for you reference.
https://support.office.com/en-us/article/QuickStart-Learn-DAX-Basics-in-30-Minutes-51744643-c2a5-436...
https://www.sqlbi.com/topics/from-sql-to-dax/

 

Regards,

Charlie Liao
 

jmalone
Resolver III
Resolver III

Is there a reason you need this table as a calculated table using DAX?

 

It may be easier to use the Query Editor to import your tables (origin, destination, FreightPayer, and CRMOwner) as separate queries, rename the headers, then append into a single table.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors