KPI card - multiple period (years)

[Anonymous]

Hi everyone,

First time poster, long time viewer.

Is it possible for a KPI card to compare actual vs plan across two years (i.e. 24 months)?

When I select both years in the filter, only 2020 appears.

[dax · Accepted solution]

Hi dever2018,

Below is my design

You could create another table like below

Table 3 = UNION (
      
    VALUES ( t6[date].[Year] ),
   
    ROW ( "subname", "TOTAL" )
)

Then use this in KPI

Best Regards,
Zoe Zhi

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

[Anonymous]

Thanks so much @dax ! I created a new column = 1 and insered to the Trend axis. It worked a treat!

[sturlaws]

Hi @Anonymous,

have you considered handling it with a measure?

Revenue =
CALCULATE (
    SUM ( Table[RevenueCol] );
    FILTER (
        ALL ( date );
        year <= SELECTEDVALUE ( year )
            && year
                >= SELECTEDVALUE ( year ) - 1
    )
)

[Anonymous]

Will give it a go - appreciate the prompt response!