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.
Hello all
Please bear with me, as my programming and Power BI skills are still relatively basic. Have done a search and couldn't find anything related to my query.
I was wondering if it was possible to equally apportion values over time based on a date field?
Data is based on enrolment units, with a number value for hours and start and end date values.
Eg Row level Data:
Unit Name Department Hours Start Date End Date
ABC Electrical 30 1/01/2021 31/03/2021
DEF Hospitality 50 1/03/2021 31/04/2021
Based on the data above, would equally distibute the hours value over time based on the start and end dates, so it would look something like this, is this even possible?
Total Hours by Department
Department Jan 21 Feb 21 Mar 21 Apr 21
Electrical 10 10 10
Hospitality 25 25
Total 10 10 35 25
Again my skills are still basic and this may be a very stupid question. Apologies in advance. Apologies for the formatting also.
Solved! Go to Solution.
@Ry_009 ,
I have a blog for day level, you can do it at month level
Or consider file for new table
Amit, wow, thank you so much for your assitance, after a bit of trial and error, it worked great!
Is there a way though to distribute evenly by months?
I would love to learn more from you via your videos, do you have particular one where I could learn this functionality in more detail? Or start with your beginner videos?
Thanks again, have really made a difference to my learning 🙂
@Ry_009 ,
I have a blog for day level, you can do it at month level
Or consider file for new table
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |