Forum Discussion

goutham's avatar
goutham
Frequent Visitor
7 years ago

LFL Calculations - YOY comparison using SamePeriod Last year function

Hi Everybody ,     I am trying to calulate LFL year on year growth . but getting incorrect results as the sameperiodlastyear function applying the logic on LFL flags in transaction as well.    F...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
7 years ago

goutham,

 

You can use PREVIOUSYEAR() instead and check if it can meet your requirement:

Revenue PY =
CALCULATE (
    SUM ( DATETABLE[REVENUE] ),
    PREVIOUSYEAR ( DATETABLE[Date] ),
    ALL ( DATETABLE[LFL Status] )
)

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

goutham's avatar
goutham
Frequent Visitor
7 years ago

v-yuta-msft , 

 

thank you for the reply !

 

No unfortunately even this function behaves the same way .  I have made few changes at data level to handle this . created  few flags.

 

This is working perfect. I shall share the details soon.

 

 

Regards

Goutham Dasari

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

    goutham ,

     

    Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

     

    Regards,

    Jimmy Tao