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.
Hi All
I have 2 tables : Table 1 and Table 2 , (1 --> M relation)
In Table 1: I am creating the following calculated column:
TableA[Col Z] =
LOOKUPVALUE(
TableB[Col X] , Table[B] [Col Y], "String_Value",
TableA[Col PK] , TableB[Col SK] ,
"N/A")
This line work great .
I need help for 2 things:
Thanks in advance
@Nazdac911 , A new column in Table A
Coalesce(maxx(filter(Table2, Table[2] = "Value"), Table2[X]) , 0)
or
Coalesce(sumx(filter(Table2, Table[2] = "Value"), Table2[X]) , 0)
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Hi
Thank you for the fast reply ..
I will need to digest the coalsec function , i never work with it before ..
but unfortunality it did not work and gave me the follwoing error message
I updated my lookupvalue function and added the Value is a string value ( all relative columns are string columns)
Thank you for sharng the youtube videios , they are of great value
Regarda
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 |
---|---|
49 | |
26 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
43 | |
19 | |
18 |