Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
Need some help to implement a report/dashboard that divides the total balance hours based on start date and end date . Currently I have no idea how to implement this on Power BI.
Based on below sample data :
What I want to achieve is :
(1) I want to display a table similar to below but the all the hours are spread between the start date and end date .Currently below the hours are not spread based on start and end date
I will convert this to chart later on but i would like first solve on how to implement this
Thanks and Regards,
Hairul
Solved! Go to Solution.
Hi @Anonymous
Is this what you're looking for?
Distributed Hrs =
SUMX (
GENERATE (
'Table',
FILTER (
VALUES ( 'Date'[Date] ),
'Date'[Date] >= 'Table'[Start Date]
&& 'Date'[Date] <= 'Table'[Due Date]
)
),
[Calculated_BalanceHrs] / 'Table'[No of Days]
)
Hi @tamerj1 , in my current Power BI i have linked the relationship my Calendar table which is Calendar[Date] column with StartDate of table above . Is it possible I get the same result ? Once i linked these two columns it doesnt produce same result . I do this because my report will be filter by month and week later on .
This is my result currently :
result =
Thanks and Regards,
Hairul
@Anonymous
If you need this relationship for any reason, you may try
result =
SUMX (
GENERATE (
'PowerBI_MachinePlanning',
FILTER (
CALCULATETABLE (
VALUES ( 'Calendar'[Date] ),
CROSSFILTER ( 'Calendar'[Date], PowerBI_MachinePlanning[JobOper_StartDate], NONE )
),
'Calendar'[Date] >= PowerBI_MachinePlanning[JobOper_StartDate]
&& 'Calendar'[Date] <= PowerBI_MachinePlanning[JobOper_DueDate]
)
),
( PowerBI_MachinePlanning[1 Calculated_BalanceHrs] ) / PowerBI_MachinePlanning[2. # Days]
)
otherwise just delete or deactivate it.
Hi @tamerj1 , yes this is what i want . Let me try this solution first and will get back to you if its not working
Thanks and Regards,
Hairul
User | Count |
---|---|
42 | |
28 | |
24 | |
20 | |
16 |
User | Count |
---|---|
54 | |
35 | |
18 | |
18 | |
15 |