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.
HelIo All,
I have a question about the calculated columns.
In a star model,is it possible to create a column calculated in a dimension A
with fields from another dimension B?
How do I join between the two dimensions?
Hi @Lidou_Cand,
Did these fields stored as multiple value fields or hierarchy fields? AFAIK, current power bi does not support building relationships on the hierarchy field.
If you are work with common table fields, you can add a calculated column to lookup corresponding value and use it as a key to building relationships.
Please provide more detailed information to help us clarify your scenario:
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Hi @Lidou_Cand ,
Can you share more details about your requirement. Table structures, output epected etc
Cheers
CheenuSing
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 | |
100 | |
74 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |