Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
You could use this query in Power BI desktop directly.
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
You could use this query in Power BI desktop directly.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
80 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |