Forum Discussion

luistiscornia's avatar
luistiscornia
Regular Visitor
5 years ago
Solved

biannual comparative

Hi! What formula can I apply to be able to compare the period 2019 with the period 2017 since with the measurement  CALCULATE([VOTOS TOTALES],SAMEPERIODLASTYEAR(Calendario[Año]=2017)) it throws me ...
Need Help
Tips and Tricks
Tutorial Requests
  • v-kkf-msft's avatar
    v-kkf-msft
    5 years ago

    Hi luistiscornia ,

     

    The SAMEPERIODLASTYEAR function needs to reference a date/time column. You can try the following measure:

     

    comparativa = 
CALCULATE(
    [VOTOS TOTALES], 
    FILTER(
        ALLSELECTED('Table'),
        'Table'[Year] = MAXX(
                            FILTER(
                                ALLSELECTED('Table'),
                                'Table'[Year] < MAX('Table'[Year])
                            ),
                            'Table'[Year]
                        )
    )
)

     

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

    Best Regards,
    Winniz

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

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

luistiscornia , You want to compare two values selected in the year box?

 

example

 
measure 1=
VAR minDate = MINX( allselected('Calendar') , 'Calendar'[Year] )
VAR maxDate = MAXX(allselected('Calendar') , 'Calendar'[Year] )
RETURN
CALCULATE([VOTOS TOTALES], filter('Calendar', 'Calendar'[Year] =_max)) - CALCULATE([VOTOS TOTALES], filter('Calendar', 'Calendar'[Year] =_min))