Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello -
In a table [Dates], I have a list of products with different modification dates.
I have the live date, live date - 1 year, and live date + 1 year.
I have used these dates in calculations from another table [Products] to calculate the unit sales associated with the year before the mod, a year after the mod, and % change (calculations below).
The issue is (if you take Product A as an example) - we will have a full years worth of data for 4/2020-4/2021 but not a full year for 4/2021-4/2022 (as it has not occurred yet). I want to be able to get an accurate read of the unit sales change since the modification and would like to compare just the months that have occurred thus far for each product (i.e. for Product A: 4/2020-6/2020 vs 4/2021-6/2021)
Please help!
Solved! Go to Solution.
Team -
I spent the good portion of the last day working through various solutions but, figured it out (DAX below):
Team -
I spent the good portion of the last day working through various solutions but, figured it out (DAX below):