Average Target Data Revisions in Static Table

[Anonymous]

Folks,

We have a static excel table loaded to One Drive and linked to PBI Service; updating daily.

Mock data table is as below; user-wise average targets may change multiple times, frequency differs.

In main matrix, there will be current - latest target as default in Power BI Visual. With Slicer, there will be an option to see older versions of targets and target change date as well. I'm not sure if there's an easier way to create such dataset.

I'd appreciate any idea to bring this in a simple formula.

Thanks,

User	Average Target (Current)	Month	Average Target (first)	Average Target v2	Average Target v3
Alice	1200	1	1000	1100	1150
Matt	800	1	900	1000	850
George	1000	1	1100	1050	1025
Raphael	900	1	950	1000	950
Joan	1400	1	1250	1000	1325

[v-shex-msft]

Hi @Anonymous,

It will be help if you share sample data and expected result.

>> With Slicer, there will be an option to see older versions of targets and target change date as well.
If you mean use multiple slicer to filter on same table to get different target. You can't get multiple filter result based on same datasource.

For your requirement, you need to create multiple tables as source slicer to get different filter result. 

Regards,

Xiaoxin Sheng