cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mazedreamer Helper I
Helper I

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,

 

UserAverage Target (Current)MonthAverage Target (first)Average Target v2Average Target v3
Alice12001100011001150
Matt80019001000850
George10001110010501025
Raphael90019501000950
Joan14001125010001325
1 REPLY 1
Highlighted
Community Support
Community Support

Re: Average Target Data Revisions in Static Table

Hi @mazedreamer,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors