Forum Discussion

jmateu88's avatar
jmateu88
Icon for Helper I rankHelper I
4 years ago
Solved

Get values from previous year from today

Hello, after some research without success, I decided to do my first post in this platform. What I'm looking for, is to be able to know the variation of a measure from previous years considering ...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi, jmateu88 ;

    Try it .

    Measure =
CALCULATE (
    [select_almacen],
    FILTER ( ALL ( 'table' ), [YEAR_FRAC] = MAX ( 'table'[YEAR_FRAC] ) + 1 )
)

    If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community


    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. 

jmateu88's avatar
jmateu88
Icon for Helper I rankHelper I
4 years ago

Thank you for your reply Amit but it is not what I am looking for.
To use one table would not be suitable because I need this for lots of cases.

In order to simplify it. I put an easy example:
What I want, is something which allows me to get the values with an arrow;


This is the typical which I am not interested.

Thank you anyway!