Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a data table that looks like the following:
Lease start dateLease End DateResidual value
9/1/2021 | 8/31/2027 | $1,682,174 |
9/1/2021 | 8/31/2029 | $4,364,738 |
10/1/2021 | 9/30/2028 | $1,000,000 |
10/1/2021 | 9/30/2028 | $1,000,000 |
9/1/2022 | 8/31/2030 | $3,749,198 |
The "Lease Start Date" column is associated with my Date table in PowerBI. I want to create a column chart that shows the Residual Value by "Lease End Date". Do I need to duplicate a RELATED Table and then create a new connection between Lease End Date and my Date table, or is there a way I can graph this information by Lease End Date without a RELATED?
Thanks!
Solved! Go to Solution.
Hi, @mrothschild
Are these three columns not in the same table? Can't it be used directly?
The data you provide is not clear. In my opinion, you can directly use the fields to create a chart.
The fields of the two tables that have created the relationship can be used directly.
Do you need to use the date in the date table? If you need to use fields in multiple tables, please provide a complete sample data so we can help you soon.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Community Support Team _ Janey
Using directly instead of the Date table solved it. Thanks!
Hi, @mrothschild
Are these three columns not in the same table? Can't it be used directly?
The data you provide is not clear. In my opinion, you can directly use the fields to create a chart.
The fields of the two tables that have created the relationship can be used directly.
Do you need to use the date in the date table? If you need to use fields in multiple tables, please provide a complete sample data so we can help you soon.
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please upload some insensitive data samples and expected output.
Best Regards,
Community Support Team _ Janey
Please read up on the DAX function USERELATIONSHIP and how to use it in your measures.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |