March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Currently, I have this measure I created using two different tables. Commission per unit sold = SUM ( Table1[total commission] ) / SUM ( Table2[units sold] ). How can I show this measure over time on a line graph if Table 1 and Table 2 each have a month column? For some reason, no matter if I plot Table1[month] by commission per unit sold or Table2[month] by commission per unit sold, neither of those work. I get an infinity in it, but the measure commission per unit sold itself works without the line graph.
Solved! Go to Solution.
Create a Date Table and then create a relationship between the date table and these two tables.
Take a look: https://www.excelcampus.com/tables/calendar-table-explained/
Create a Date Table and then create a relationship between the date table and these two tables.
Take a look: https://www.excelcampus.com/tables/calendar-table-explained/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
98 | |
89 | |
72 | |
62 |
User | Count |
---|---|
140 | |
121 | |
106 | |
98 | |
94 |