topic Hi Team. How to get a daily target for each sales person when given a monthly target without a daily in DAX Commands and Tips

Hi Team. How to get a daily target for each sales person when given a monthly target without a daily

MalusiNdamani — Thu, 16 May 2024 09:06:56 GMT

Re: Hi Team. How to get a daily target for each sales person when given a monthly target without a daily

Anonymous — Fri, 17 May 2024 01:52:47 GMT

What is the logic for calculating daily goals? Is it a monthly goal averaged over each day? If so, you can calculate the number of days in the corresponding month and then divide the monthly goal by the number of days in that month.

Here's how to calculate the number of days per month.

column = DAY(EOMONTH([YourColumnName], 0))

If the formula doesn't work for you, please provide some sample data and the expected results based on the sample so that I can better help you. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Hi Team. How to get a daily target for each sales person when given a monthly target without a daily

MalusiNdamani — Mon, 20 May 2024 10:40:08 GMT

Hi Yulia,

Thak you for the speedy response.

My task is i recieve montly target now i want to break it down to days vs. the sale that I recieve daily.

Please see the below sample that i am working on.

Target Test - Power BI