Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SAMEPERIODLASTYEAR ISSUE

SAMEPERIODLASTYEAR  Issue I have a very simple data set, that is a sub set of a larger data set where I am trying to create a measure to determine a value for same period last year. Data basically ...
Need Help
Tutorial Requests
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, Anonymous ;

    You could cahnge the measure .

    PriorYRActuals2 = 
CALCULATE(SUM('vw_PL_Analysis'[ActualsBookUSD]),SAMEPERIODLASTYEAR('vw_PL_Analysis'[pbixDate]),ALL(vw_FiscalStartDate))

    The final output is shown below:

     

    Or change the visual.


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

You could cahnge the measure .

PriorYRActuals2 = 
CALCULATE(SUM('vw_PL_Analysis'[ActualsBookUSD]),SAMEPERIODLASTYEAR('vw_PL_Analysis'[pbixDate]),ALL(vw_FiscalStartDate))

The final output is shown below:

 

Or change the visual.


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.