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.
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
Solved! Go to 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
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
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |