AB,
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.
----------------------------------
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?)
Proud to be a Super User! |  |
Hello AB2,
Try this as a column in your Vehicle Sales table.
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] >= DateSold
)
VAR FirstServiceDate = MINX ( SrvHistFiltered, 'Service History'[RO Date] )
VAR EightMonthsAfterSale = EDATE ( DateSold, 8 )
RETURN
IF ( FirstServiceDate > DateSold && FirstServiceDate <= EightMonthsAfterSale, 1, 0 )
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.
----------------------------------
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?)
Proud to be a Super User! | |
AB,
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.
----------------------------------
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?)
Proud to be a Super User! | |
You're welcome, glad you got it working. 😄
Proud to be a Super User! | |
Hello AB2,
Thanks for making your data easy to replicate. 😄
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 or after)? I started looking at this assuming RO dates would only be after sale date but that doesn't seem to be the case.
Also, do you also have a sample report output/format you're looking for? That part was a little ambiguous to me.
Proud to be a Super User! | |
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
We want your feedback!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
A Year in Review - December 2024
Find out what content was popular in the Fabric community during 2024.
