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.
Hello everyone,
it's the first time I write.
I have this problem:
I don't want to leftjoin between table1 and table2, because table1 is 3 million rows and works with direct query.
I am looking for some suggestions to create a measure or a calculated column.
Thanks in advance.
Alex.
Solved! Go to Solution.
Hi @ALE_P
Create simple measure as below,
Create columnn like this in first table
syntax: LOOKUPVALUE( <result_columnName>, <search_columnName>, <search_value>)
this function returns a value, not a column, so i tried to make a measure, but the <search value> parameter is a value, and not a column.
Itried with DISTINCT, but "This function cannot be used to Return values into a cell or column".
the idea was good....
ps.: there is already a relationship many-to-one between Table1 and Table2.
Sorry, but as I wrote, LOOKUPVALUE it doesn't work.
Hi @ALE_P
Create simple measure as below,
Hey
take a look at this solution . As u have a large datastet ( millions of rows that is better to create a measure and not calculated columns)
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 |
---|---|
47 | |
26 | |
22 | |
12 | |
8 |
User | Count |
---|---|
77 | |
50 | |
46 | |
16 | |
12 |