Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
User | Count |
---|---|
73 | |
70 | |
38 | |
25 | |
23 |
User | Count |
---|---|
96 | |
93 | |
50 | |
43 | |
42 |