cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mazedreamer Regular Visitor
Regular Visitor

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
Community Support Team
Community Support Team

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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors