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
