Stats for last 5 years based on year slicer

[JP1983]

Hi

I am kind of stuck with the below scenario and yet no Luck 😞

Hope you guys can help me .

Many Thanks for your assistance!

[v-gizhi-msft · Accepted solution]

Hi,

Please try to create this column in Table B:

Column = VALUE(20&RIGHT(LEFT('Table B'[Pid],3),2))

Then create a measure:

Measure = IF(MAX('Table B'[Column])>=SELECTEDVALUE('Table C'[Year])-5&&MAX('Table B'[Column])<=SELECTEDVALUE('Table C'[Year]),1,0)

Choose above column and Count of Pid as a table visual, apply above measure to this visual by setting meausre=1.

When select one year in slicer, it shows:

Best Regards,

Giotto Zhi

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490