Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi ,
I need to calculate the sum of efforts spend on each task for particular month , i have a column in my excel sheet as Actual hours and Actual hours1 ,Actual hours2.
For example , If the task is started on January month and ended in Febrauary month ,then the Actual efforts are splitted as Actual hour1 for january and Actual hour2 for February. So if i need to calculate the January month effort it should calculate as Actual Hour (Jan)+ Actual Hour 1.
That is 104 hours for January
For February its should be Actual hour ( Feb )+ Actual Hour2 =44
Could ypu please help to insert a conditional column as above to create the dash board
@VigneshM25 , Not very clear.
But this approach should help
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
User | Count |
---|---|
56 | |
22 | |
18 | |
16 | |
11 |
User | Count |
---|---|
85 | |
54 | |
39 | |
21 | |
18 |