Adding functions with parameters from different tables

[ikkew]

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

[v-yuta-msft · Accepted solution]

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