YoY % variance in a Card visual ?

Hi LuisNC,

I see 2 possible solutions:

1.- Use Power BI Time Intelligence. You would need to add Date into the card’s filter pane and set the filter to Relative date. Then set that to the current year. But note this would assume you have 2023 data. If so then the DISTINCTCOUNT() function would recognize you just need the current year.
For previous year you would use the function PREVIOUSYEAR () to get previous year data.

Now since in the example the Max year is 2017 I would recommend building a measure that identifies this and uses that to build the desired output.

2.- The measure would be:

Count of Ortder_ID YoY% =

VAR CURR_YEAR =
                CALCULATE(
                                DISTINCTCOUNT(‘Order’[Order_UD],
                                ‘Date’[Year] = MAX(‘Date’[Year])
                )

VAR PREV_YEAR =

                CALCULATE(
                                DISTINCTCOUNT(‘Order’[Order_UD],
                                ‘Date’[Year] = MAX(‘Date’[Year])-1
                )

RETURN
                DIVIDE((CURR_YEAR – PREV_YEAR),PREV_YEAR)

It is low tech but should work.

Let me know how it goes.

Regards,