Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I need help in making a chart.
Below I described the problem in the excel sheet.
I have a data table with three columns (Start_date, End_date and Time_cost)
I want to plot this data in the chart as follows.
The Time_cost is to be divided by the number of days in which the Project occurs and placed in individual days in which it occurs. Just like in the Excel chart below
For better understanding, I put everything in an excel file
Link to file http://gofile.me/74fh2/cc0521h8J
I am asking for help in solving this problem
Solved! Go to Solution.
@amiskow , refer these approches
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
Hi,
Please find attached the PBI file.
Hope this helps.
Thank you very much for help. That's exactly what it was about 😊
You are welcome.
@amiskow , refer these approches
Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM
Tables way
https://amitchandak.mediumcom/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
97 | |
95 | |
68 | |
65 |