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
ikkew
Advocate I
Advocate I

Adding functions with parameters from different tables

After adding a Scalar-valued Function from my database, I try and call this function but am unable to fill in the parameters as requested. I can only select the columns of the table selected when adding the function. No other columns can be used.

 

Screenshot with the described step (Dutch): https://imgur.com/a/KpbWle9

 

I have to pass columns from different tables for my function to work, is this possible?

If not, how can I transform a regular SQL-statement containing JOINS and WHEREs to a DAX-statement?

 

The SQL-statement:


SELECT @MinMaxValue = MIN(FactPrijs)
FROM ArtikelM
INNER JOIN Leverancier
    ON ArtikelM.LevId = Leverancier.LevId
INNER JOIN Klanten
    ON ArtikelM.KlantenId = Klanten.KlantenId
WHERE ArtikelId = @ArtikelId
    AND Klanten.KlantTypeCategorie = @KlantType
    AND Klanten.KlantGrootteCategorie = @KlantGrootte

1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

Hi ikkew,

 

To do "join" function in power bi, you don't need to write any DAX formula, click query editor-> Merge Queries. In addtion, if you still want to create this merged table using DAX, please refer to summarize().

 

Regards,

Jimmy Tao

View solution in original post

1 REPLY 1
v-yuta-msft
Community Support
Community Support

Hi ikkew,

 

To do "join" function in power bi, you don't need to write any DAX formula, click query editor-> Merge Queries. In addtion, if you still want to create this merged table using DAX, please refer to summarize().

 

Regards,

Jimmy Tao

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.