Chart (date difference with value)

[amiskow]

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

[amitchandak · Accepted 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

[amiskow]

@Ashish_Mathur @amitchandak 

Thank you very much for help. That's exactly what it was about 😊

[Ashish_Mathur]

You are welcome.

[Ashish_Mathur · Accepted solution]

Hi,

Please find attached the PBI file.

Hope this helps.

[amitchandak · Accepted 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