Forum Discussion

jppuam's avatar
jppuam
Icon for Helper V rankHelper V
7 years ago

dinamic accouting

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, becaus...
Need Help
jppuam's avatar
jppuam
Icon for Helper V rankHelper V
7 years ago

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 - 8)

.....

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

v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

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