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.
So I have a dates, hour, and goals query.
A monthly goal is August "3000" hours, so my daily one is 96.77. I am trying to get my goals column to increase by 96.77 every day of August until it's 3000.
For example my goals table I have:
Month | Goal | Daily Goal
7/1/2017 | 4532 | 146.19
8/1/2017 | 4000 | 96.77
How could I get it to associate my daily goal with a date in Dates and add "96.77" to itself each day of the month?
Hi @michellerosen,
Did you means use target table to create the rolling total calendar?
If this is a case, you can refer to below sample.
1. Calculate column daily target:
Daily = [Total Goal]/DAY(DATE([Date].[Year],[Date].[MonthNo]+1,1)-1)
2. Rolling target calendar based on target table.
CALENDAR = ADDCOLUMNS(SELECTCOLUMNS(CALENDAR(DATE(2017,1,1),TODAY()),"Date",[Date],"Daily Goal",LOOKUPVALUE(Records[Daily],Records[Date],DATE(YEAR([Date]),MONTH([Date]),1))),"Rolling",DAY([Date])*[Daily Goal])
If above not help, please share some sample data to analysis.
Regards,
Xiaoxin Sheng
Michellerosen,
I thought we had this sovled before.... What's new / different, or what are we missing that I can help with again?
https://community.powerbi.com/t5/Desktop/Make-monthly-goal-into-daily-goal/m-p/233447
Thank You,
Forrest
Proud to give back to the community!
Thank You!
The solution worked but only if I used the dates I made in the Daily Table. It wouldn't work with the dates in my Dates table, and for some reason when I added my dates in the Daily Table they would all be for the same day regardless of filter.
Any chance you can share a copy of your PBIX file so we can review? As you are looking for Day level detail, you'll have to have a Date table, but any Date table (as long as it has 1 entry for every date) should have worked just fine...?
FOrrest
Proud to give back to the community!
Thank You!
If you are going to have a table\matrix that is by day, and you have your daily goal, you could just multiply the daily goal by the month day:
Get day of month: DAY('Calendar'[Date])
Get goal value rolleed up:
=DAY('Calendar'[Date]) * DailyGoal
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |