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 Everyone,
Is there any way to use both active and inactive relationships in one calculated column? I have the following calculated column;
@Anonymous , Not very clear.
First of all Do use .date unless there is a timestamp. If it is datetime. Create a new date column and join with the date table. If you have more than one dates in one table then you need inactive relation and use relation.
or video -https://youtu.be/e6Y-l_JtCq4
Yes they all have time stamp hence I use .[Date]. I have more than one date column in my table and I created one active and 2 inactive relationships between SHIPPING_LINE tabel and Date table. However, I do not know how to use "USERELATIONSHIP" within one calculate function as described above.
Hi @Anonymous ,
Could you pls upload the relationship schema between tables?
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 |
---|---|
115 | |
100 | |
90 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |