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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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