Forum Discussion
Daily Sales Target
- 5 years ago
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Also, refer if this blog can help you a bit
Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400
- 5 years ago
Anonymous
To calculate the working days remaining until the end of year, you can try:
1) Include a column in your calendar table to identify working days (in my case working days exclude Saturdays and Sundays, but adjust according to your setting):
2) Create a simple SUM measure for working days:
Sum Working days = SUM('Calendar Table'[Working Days])3) Calculate the working days remaining until the end of the current year:
Remaining Working Days Measure = VAR _EndOfYear = DATE(YEAR(TODAY()), 12, 31) RETURN CALCULATE([Sum Working days], REMOVEFILTERS(), FILTER(ALL('Calendar Table'[Date]), 'Calendar Table'[Date] > TODAY() && 'Calendar Table'[Date] <=_EndOfYear))Now you can divide the remaing sales target by the remaining working days
PS If you wish to calculate the remaining working days (Monday - Firday) using only a measure (without including a column in the Calendar Table), you can use:
Measure Remaing Working Days = VAR EOYEAR = DATE(YEAR(TODAY()), 12, 31) RETURN COUNTROWS( FILTER(ALL('Calendar Table'[Date]), 'Calendar Table'[Date] > TODAY() && 'Calendar Table'[Date] <= EOYEAR && WEEKDAY('Calendar Table'[Date], 2) IN {1,2,3,4,5}))
Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Also, refer if this blog can help you a bit
Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400