title: Power BI Divide two measure from different tables and show in a graph with time
body: <p>I have two tables, Table one has daily data, Table two has weekly data. I've created a start of week column in Table 1 to get weekly data. Data is as shown below : <a href="https://i.stack.imgur.com/VnzcK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VnzcK.png" alt="enter image description here" /></a></p>
  <p>I want to create a table where I can divide these two measures. Both measures are counts in a week. I want to present this in a line/bar chart with time at the x-axis. Right now when I use the Date of Table 1, My measure 2 takes the overall count as the date of table 2 is not present and vice versa. I was thinking of creating a new Calendar table but I'm unable to get these measure values in that table.</p>
  <p>I tried creating a custom calendar table but I'm not getting the desired result. I'm getting correct values from table 2 but no values from table 1. I feel the problem is because table 1 has duplicate date values.</p>
  <p>Table 1 actual data before consolidation:Measure is the count of case numbers
  <a href="https://i.stack.imgur.com/2RBNd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2RBNd.png" alt="enter image description here" /></a></p>