Forum Discussion

jppuam's avatar
jppuam
Helper 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
affan's avatar
affan
Solution Sage
7 years ago

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

jppuam's avatar
jppuam
Helper 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
    Community 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