I hope this email find you all well
Per the attached sample customer and BU sales data. I’m need help with creating a Dax measure to show the sales $ variance by year (2019 and 2020) for each customer. Also what is the best to show a YTD and MTD view for this analysis?
Thank you in advance for your help
Variance Calculation.pbix (29.3 KB)