Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Till
Resolver II
Resolver II

Weighted average of targets

Hi All,
I have a list of different targets per day.
I am looking for a measure that gives me back a weighted average of the targets.
Thanks for your help

Unbenannt.PNG

 Kind Regards
Till

1 ACCEPTED SOLUTION
Anonymous
Not applicable
3 REPLIES 3
Till
Resolver II
Resolver II

Thanks for the help.

Kind regards
Till

v-yalanwu-msft
Community Support
Community Support

Hi, @Till ;

First of all, Power BI can get the result of weighted average through DAX,
but I looked at your data and found that you lack the weight of weighted average. Did you mention what measure to use, it depends on your own needs, if there is no weight, you can consider just taking the average, or what kind of result output do you need?

 

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.