Forum Discussion
Average Target Data Revisions in Static Table
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 |
1 Reply
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