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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
abhijit123
Regular Visitor

Power Bi

How to convert Monthly target into daily considering location, Version no.?

1 REPLY 1
v-jingzhang
Community Support
Community Support

Hi @abhijit123 

 

The information you provided is not enough to make the question clear. Can you provide some sample data and expected result in table format to help explain what you want to get? 

 

If you want to break a monthly target into daily target, a common practice is to divide it by days of a month. If you want to break it considering location, Version no., you can divide the target by number of locations, number of version no. This is totally based on the average.

 

If you want to have weighted averages for different objects, the solution will be different. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

Helpful resources

Announcements
60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.