Forum Discussion
conditional join from sql server to power bi in direct query mode
Hi, I am importing tables from SQL Server into Power BI in Direct Query mode. Between two tables in SQL Server there is a conditional join, “many to one” , with this query: Sales.Promo=DER.R6A and ...
yes bot what to write there?
second question, in the query you wrote
measure = Calculate(Distinctcount(sales.uniqueid), Sales.Data>=DER.F6A,
Sales.Data<=DER.F6B)
but how to select DER.F6A? with selectcolumns?
many thanks!
AnushaSri
Resolver II
Resolver IIThis is the query you can write, and instead of * (unless you want to get all columns from both sales and der tables) write the column names of what ever the columns you need.(like select column1, column2, column3 from.....)
Select
* from
sales
join DER ON Sales.Promo=DER.R6A and
Sales.Data>=DER.F6A and
Sales.Data<=DER.F6B