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.
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
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 |
---|---|
96 | |
94 | |
82 | |
70 | |
64 |
User | Count |
---|---|
116 | |
106 | |
94 | |
79 | |
72 |