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,
Can someone help me with this?
I have two table without any relationsship.
I need a calculated colum in the PayTable from the CallsTable.
The calculation rule is the first date from the CallsTable but not equal.
Greetz,
Ronald
Solved! Go to Solution.
Hi Ronald123,
To be general, are date in column Table Calls[CallDate] unique? To use lookupvalue(), or other similar function like related(), you should build a one-many relationship between the two tables, then use column in one-side as a filter condition to achieve the value you want.
Regards,
Jimmy Tao
Hi Ronald123,
To be general, are date in column Table Calls[CallDate] unique? To use lookupvalue(), or other similar function like related(), you should build a one-many relationship between the two tables, then use column in one-side as a filter condition to achieve the value you want.
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |