Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
awu3639
Frequent Visitor

Plotting calculated field from two tables over time in a line graph

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. 

image.png

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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/

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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/

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.