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 an error.
Thank you so much!
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.

2 Replies

  • 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))

  • v-kkf-msft's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    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.