topic Re: Looking for assistance on Dax for report building in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3214038#M117299 <P>Hi Wilson;</P><P>I have tried that and it returns the 0 value.&nbsp; The dates on the sample are my mistake in replicating the data.&nbsp; i made an error on the dates. I have edited the dates but&nbsp; it returns 1 even when the date is over 8 months ?&nbsp; Could it bee that it is not Matching the vin#'s on the vehicle sales table and the Service history table?&nbsp; here are the edited tables</P><P>Service History</P><TABLE><TBODY><TR><TD>Dealer Code</TD><TD>Dealer Name</TD><TD>Service VIN</TD><TD>Model Year</TD><TD>Service RO Number</TD><TD>RO Date</TD><TD>Total RO's</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>SA26013</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>ST83176</TD><TD>02/01/23</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>ST85628</TD><TD>03/01/23</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2022</TD><TD>SA00628</TD><TD>06/01/23</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>SA08750</TD><TD>05/01/23</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>SA20569</TD><TD>05/01/23</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>SA31535</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>SA42994</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>ST79067</TD><TD>02/01/23</TD><TD>1</TD></TR><TR><TD>123483</TD><TD>123483 Toyota</TD><TD>1168</TD><TD>2022</TD><TD>ST93092</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123486</TD><TD>123486 Toyota</TD><TD>1173</TD><TD>2022</TD><TD>SA20559</TD><TD>12/01/23</TD><TD>1</TD></TR><TR><TD>123489</TD><TD>123489 Toyota</TD><TD>1178</TD><TD>2022</TD><TD>SA40133</TD><TD>03/01/23</TD><TD>1</TD></TR><TR><TD>123492</TD><TD>123492 Toyota</TD><TD>1183</TD><TD>2022</TD><TD>SA05676</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123495</TD><TD>123495 Toyota</TD><TD>1188</TD><TD>2022</TD><TD>SA21173</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123498</TD><TD>123498 Toyota</TD><TD>1193</TD><TD>2022</TD><TD>SA26829</TD><TD>02/01/23</TD><TD>1</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>ST99577</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>SA06770</TD><TD>02/01/23</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>SA18667</TD><TD>06/01/23</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2022</TD><TD>SA25137</TD><TD>06/01/23</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>SA28709</TD><TD>05/01/23</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>SA35554</TD><TD>06/01/23</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>SA38248</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>ST96375</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>SA02544</TD><TD>02/01/23</TD><TD>1</TD></TR></TBODY></TABLE><P>Vehicles Sales</P><TABLE><TBODY><TR><TD>Dealer Coder</TD><TD>Dealer Name</TD><TD>Vehicle Identification Number (VIN)</TD><TD>Model Year</TD><TD>Sale Date</TD><TD>Units Sold</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>07/2022</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2023</TD><TD>04/2023</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>09/2022</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123483</TD><TD>123483 Toyota</TD><TD>1168</TD><TD>2022</TD><TD>08/2022</TD><TD>1</TD></TR><TR><TD>123486</TD><TD>123486 Toyota</TD><TD>1173</TD><TD>2022</TD><TD>11/2022</TD><TD>1</TD></TR><TR><TD>123489</TD><TD>123489 Toyota</TD><TD>1178</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123492</TD><TD>123492 Toyota</TD><TD>1183</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123495</TD><TD>123495 Toyota</TD><TD>1188</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123498</TD><TD>123498 Toyota</TD><TD>1193</TD><TD>2022</TD><TD>07/2022</TD><TD>1</TD></TR></TBODY></TABLE> Mon, 01 May 2023 16:29:12 GMT AB2 2023-05-01T16:29:12Z Looking for assistance on Dax for report building https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3213687#M117272 <P>Good Morning;&nbsp;</P><P>I am trying to create a report that will look at the vin#&nbsp; and sale date in one table an match the VIN # in another table and look at the RO dates for that vin. if the date on the ro is with 8 months of the sale date return a value of "1" of not then "0". I have attached a sample of the data i am using. any help would be greatly appreciated.&nbsp;&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P><P>Vehicle Sales</P><TABLE><TBODY><TR><TD>Dealer Coder</TD><TD>Dealer Name</TD><TD>Vehicle Identification Number (VIN)</TD><TD>Model Year</TD><TD>Sale Date</TD><TD>Units Sold</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>07/2022</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2023</TD><TD>04/2023</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>09/2022</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123483</TD><TD>123483 Toyota</TD><TD>1168</TD><TD>2022</TD><TD>08/2022</TD><TD>1</TD></TR><TR><TD>123486</TD><TD>123486 Toyota</TD><TD>1173</TD><TD>2022</TD><TD>11/2022</TD><TD>1</TD></TR><TR><TD>123489</TD><TD>123489 Toyota</TD><TD>1178</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123492</TD><TD>123492 Toyota</TD><TD>1183</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123495</TD><TD>123495 Toyota</TD><TD>1188</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123498</TD><TD>123498 Toyota</TD><TD>1193</TD><TD>2022</TD><TD>07/2022</TD><TD>1</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Service History</P><TABLE><TBODY><TR><TD>Dealer Code</TD><TD>Dealer Name</TD><TD>Service VIN</TD><TD>Model Year</TD><TD>Service RO Number</TD><TD>RO Date</TD><TD>Total RO's</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>SA26013</TD><TD>03/2022</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>ST83176</TD><TD>03/2020</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>ST85628</TD><TD>05/2020</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2022</TD><TD>SA00628</TD><TD>12/2020</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>SA08750</TD><TD>05/2021</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>SA20569</TD><TD>12/2021</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>SA31535</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>SA42994</TD><TD>01/2023</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>ST79067</TD><TD>01/2020</TD><TD>1</TD></TR><TR><TD>123483</TD><TD>123483 Toyota</TD><TD>1168</TD><TD>2022</TD><TD>ST93092</TD><TD>08/2020</TD><TD>1</TD></TR><TR><TD>123486</TD><TD>123486 Toyota</TD><TD>1173</TD><TD>2022</TD><TD>SA20559</TD><TD>12/2021</TD><TD>1</TD></TR><TR><TD>123489</TD><TD>123489 Toyota</TD><TD>1178</TD><TD>2022</TD><TD>SA40133</TD><TD>11/2022</TD><TD>1</TD></TR><TR><TD>123492</TD><TD>123492 Toyota</TD><TD>1183</TD><TD>2022</TD><TD>SA05676</TD><TD>04/2021</TD><TD>1</TD></TR><TR><TD>123495</TD><TD>123495 Toyota</TD><TD>1188</TD><TD>2022</TD><TD>SA21173</TD><TD>12/2021</TD><TD>1</TD></TR><TR><TD>123498</TD><TD>123498 Toyota</TD><TD>1193</TD><TD>2022</TD><TD>SA26829</TD><TD>04/2022</TD><TD>1</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>ST99577</TD><TD>12/2020</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>SA06770</TD><TD>04/2021</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>SA18667</TD><TD>11/2021</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2022</TD><TD>SA25137</TD><TD>03/2022</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>SA28709</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>SA35554</TD><TD>09/2022</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>SA38248</TD><TD>10/2022</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>ST96375</TD><TD>10/2020</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>SA02544</TD><TD>02/2021</TD><TD>1</TD></TR></TBODY></TABLE> Mon, 01 May 2023 12:28:17 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3213687#M117272 AB2 2023-05-01T12:28:17Z Re: Looking for assistance on Dax for report building https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3213743#M117274 <P>Hello AB2,</P><P>&nbsp;</P><P>Thanks for making your data easy to replicate. <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P><P>&nbsp;</P><P>When you say "the RO is within 8 months of the sale date", do you mean on either side of the sale date (ie: within eight months before&nbsp;<EM>or</EM> after)? I started looking at this assuming RO dates would only be after sale date but that doesn't seem to be the case.</P><P>&nbsp;</P><P>Also, do you also have a sample report output/format you're looking for? That part was a little ambiguous to me.</P> Mon, 01 May 2023 12:52:08 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3213743#M117274 Wilson_ 2023-05-01T12:52:08Z Re: Looking for assistance on Dax for report building https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3213769#M117277 <P>IHello Wilson,&nbsp; My apologies yes it would be after the sale date within the 8 months. as far as output if i could have it as a column on the vehicles sales table that would be great. as i could then calculate the percentage of vehicle sales and how many return for service within 8 months.&nbsp; &nbsp;kind of like like the below table.&nbsp; Thank you again for any help. much appreciated&nbsp;</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>Dealer Coder</TD><TD>Dealer Name</TD><TD>Vehicle Identification Number (VIN)</TD><TD>Model Year</TD><TD>Sale Date</TD><TD>Units Sold</TD><TD>Serviced with 8 mths</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>07/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2023</TD><TD>04/2023</TD><TD>1</TD><TD>0</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>09/2022</TD><TD>1</TD><TD>0</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD><TD>0</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD><TD>0</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123483</TD><TD>123483 Toyota</TD><TD>1168</TD><TD>2022</TD><TD>08/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123486</TD><TD>123486 Toyota</TD><TD>1173</TD><TD>2022</TD><TD>11/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123489</TD><TD>123489 Toyota</TD><TD>1178</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123492</TD><TD>123492 Toyota</TD><TD>1183</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123495</TD><TD>123495 Toyota</TD><TD>1188</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD><TD>1</TD></TR><TR><TD>123498</TD><TD>123498 Toyota</TD><TD>1193</TD><TD>2022</TD><TD>07/2022</TD><TD>1</TD><TD><P>1</P></TD></TR></TBODY></TABLE> Mon, 01 May 2023 13:06:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3213769#M117277 AB2 2023-05-01T13:06:22Z Re: Looking for assistance on Dax for report building https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3213815#M117281 <P>Hello AB2,</P><P>&nbsp;</P><P>Try this as a column in your Vehicle Sales table.</P><LI-CODE lang="markup">Service Within 8 Months of Sale = VAR DateSold = 'Vehicle Sales'[Sale Date] VAR SrvHistFiltered = -- Filtering Service History table for only RO dates after the sale date; unclear why there are RO dates before sale FILTER ( 'Service History', 'Service History'[RO Date] &gt;= DateSold ) VAR FirstServiceDate = MINX ( SrvHistFiltered, 'Service History'[RO Date] ) VAR EightMonthsAfterSale = EDATE ( DateSold, 8 ) RETURN IF ( FirstServiceDate &gt; DateSold &amp;&amp; FirstServiceDate &lt;= EightMonthsAfterSale, 1, 0 )</LI-CODE><P>&nbsp;</P><P>However, I'm not getting the same results in the column as you showed here. For example, for VIN 1123, I'm only seeing service on 12/1/2020 and 3/1/2022, which are both before the sale date of 5/1/2022 (and therefore not within the 8 months following). Therefore, I'm returning a 0 on that vehicle. If that's incorrect, please let me know where I'm misunderstanding your requirements.</P><P><BR /><FONT size="2">----------------------------------</FONT><BR /><FONT size="2">If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)</FONT></P> Mon, 01 May 2023 13:58:43 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3213815#M117281 Wilson_ 2023-05-01T13:58:43Z Re: Looking for assistance on Dax for report building https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3214038#M117299 <P>Hi Wilson;</P><P>I have tried that and it returns the 0 value.&nbsp; The dates on the sample are my mistake in replicating the data.&nbsp; i made an error on the dates. I have edited the dates but&nbsp; it returns 1 even when the date is over 8 months ?&nbsp; Could it bee that it is not Matching the vin#'s on the vehicle sales table and the Service history table?&nbsp; here are the edited tables</P><P>Service History</P><TABLE><TBODY><TR><TD>Dealer Code</TD><TD>Dealer Name</TD><TD>Service VIN</TD><TD>Model Year</TD><TD>Service RO Number</TD><TD>RO Date</TD><TD>Total RO's</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>SA26013</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>ST83176</TD><TD>02/01/23</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>ST85628</TD><TD>03/01/23</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2022</TD><TD>SA00628</TD><TD>06/01/23</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>SA08750</TD><TD>05/01/23</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>SA20569</TD><TD>05/01/23</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>SA31535</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>SA42994</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>ST79067</TD><TD>02/01/23</TD><TD>1</TD></TR><TR><TD>123483</TD><TD>123483 Toyota</TD><TD>1168</TD><TD>2022</TD><TD>ST93092</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123486</TD><TD>123486 Toyota</TD><TD>1173</TD><TD>2022</TD><TD>SA20559</TD><TD>12/01/23</TD><TD>1</TD></TR><TR><TD>123489</TD><TD>123489 Toyota</TD><TD>1178</TD><TD>2022</TD><TD>SA40133</TD><TD>03/01/23</TD><TD>1</TD></TR><TR><TD>123492</TD><TD>123492 Toyota</TD><TD>1183</TD><TD>2022</TD><TD>SA05676</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123495</TD><TD>123495 Toyota</TD><TD>1188</TD><TD>2022</TD><TD>SA21173</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123498</TD><TD>123498 Toyota</TD><TD>1193</TD><TD>2022</TD><TD>SA26829</TD><TD>02/01/23</TD><TD>1</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>ST99577</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>SA06770</TD><TD>02/01/23</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>SA18667</TD><TD>06/01/23</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2022</TD><TD>SA25137</TD><TD>06/01/23</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>SA28709</TD><TD>05/01/23</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>SA35554</TD><TD>06/01/23</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>SA38248</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>ST96375</TD><TD>01/01/23</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>SA02544</TD><TD>02/01/23</TD><TD>1</TD></TR></TBODY></TABLE><P>Vehicles Sales</P><TABLE><TBODY><TR><TD>Dealer Coder</TD><TD>Dealer Name</TD><TD>Vehicle Identification Number (VIN)</TD><TD>Model Year</TD><TD>Sale Date</TD><TD>Units Sold</TD></TR><TR><TD>123456</TD><TD>123456 Toyota</TD><TD>1123</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123459</TD><TD>123459 Toyota</TD><TD>1128</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123462</TD><TD>123462 Toyota</TD><TD>1133</TD><TD>2022</TD><TD>07/2022</TD><TD>1</TD></TR><TR><TD>123465</TD><TD>123465 Toyota</TD><TD>1138</TD><TD>2023</TD><TD>04/2023</TD><TD>1</TD></TR><TR><TD>123468</TD><TD>123468 Toyota</TD><TD>1143</TD><TD>2022</TD><TD>09/2022</TD><TD>1</TD></TR><TR><TD>123471</TD><TD>123471 Toyota</TD><TD>1148</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123474</TD><TD>123474 Toyota</TD><TD>1153</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123477</TD><TD>123477 Toyota</TD><TD>1158</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123480</TD><TD>123480 Toyota</TD><TD>1163</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123483</TD><TD>123483 Toyota</TD><TD>1168</TD><TD>2022</TD><TD>08/2022</TD><TD>1</TD></TR><TR><TD>123486</TD><TD>123486 Toyota</TD><TD>1173</TD><TD>2022</TD><TD>11/2022</TD><TD>1</TD></TR><TR><TD>123489</TD><TD>123489 Toyota</TD><TD>1178</TD><TD>2022</TD><TD>05/2022</TD><TD>1</TD></TR><TR><TD>123492</TD><TD>123492 Toyota</TD><TD>1183</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123495</TD><TD>123495 Toyota</TD><TD>1188</TD><TD>2022</TD><TD>06/2022</TD><TD>1</TD></TR><TR><TD>123498</TD><TD>123498 Toyota</TD><TD>1193</TD><TD>2022</TD><TD>07/2022</TD><TD>1</TD></TR></TBODY></TABLE> Mon, 01 May 2023 16:29:12 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3214038#M117299 AB2 2023-05-01T16:29:12Z Re: Looking for assistance on Dax for report building https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3214120#M117307 <P>AB,</P><P>&nbsp;</P><P>Dumb question: Do you have a relationship created in Power BI between the two tables like this? I assumed you had it in your data model, because otherwise, you're correct. My calculated column measure would not be taking the VIN into account.</P><P>&nbsp;</P><P><img /></P><P><BR /><FONT size="2">----------------------------------</FONT><BR /><FONT size="2">If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)</FONT></P> Mon, 01 May 2023 17:41:41 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3214120#M117307 Wilson_ 2023-05-01T17:41:41Z Re: Looking for assistance on Dax for report building https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3215535#M117388 <P>Good Morning Wilson;</P><P>&nbsp; &nbsp;I had the relationship but i did not have it correctly set up.&nbsp; it works now. thank you very much for your assistance.&nbsp; &nbsp;much appreciated&nbsp;</P> Tue, 02 May 2023 11:38:57 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3215535#M117388 AB2 2023-05-02T11:38:57Z Re: Looking for assistance on Dax for report building https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3215984#M117416 <P>You're welcome, glad you got it working. <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P> Tue, 02 May 2023 15:17:24 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Looking-for-assistance-on-Dax-for-report-building/m-p/3215984#M117416 Wilson_ 2023-05-02T15:17:24Z