Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
i need to analyse to viability of several projets,
in this example i have a project that starts on march 16.
So to compare in 2017, i cannot compare jan and fev of 2017, because i have to compare 2017 with 2016.
But in 2018, i have to compare the full year of 2018 and 2017.
How can i do a formula to make the diference of the several years dinamically ?
thanks,
JR
Hi @jppuam
If you have data as shown in the above table and you want to compare it, can you please share what is your expected outcome?
Regards,
Affan
What i want is the diference between 2017/2016, and 2018/2017.
So the result would be :
march 2017 - march 2016 = (7 - 7)
april 2017 - april 20216 = (6 - 😎
.....
thus, i have the diferent between 2017 and 2016.
But when i do the varition between 2018 and 2017, i have :
jan 2018 - jan 2017
fev 2018 - fev 2017
....
so i'll have the diference 2018 - 2017
the question for me is, becasuse the projet start em mar 2016, how can i make the operations with 2017. Because, i cant considerer the jan e fev of 2017, when compare to the 2016, but i have to considerer when making the variation regarding 2018.
i dont know if its was clear,
thanks,
JR
hi, @jppuam
You may try to use SAMEPERIODLASTYEAR Function to create a measure like below:
Measure = CALCULATE(SUM(Table2[Sales]),SAMEPERIODLASTYEAR(Table2[Date]))
Difference
Measure 2 = CALCULATE(SUM(Table2[Sales]))-[Measure]
or
Measure 3 = IF(ISBLANK([Measure])=FALSE(),CALCULATE(SUM(Table2[Sales]))-[Measure])
Result:
Best Regards,
Lin
Hi,
How is your base data arranged and what end result are you expecting?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |