Create graph by start , end date

[paris]

Hi All,

I like to create a graph by start and end date. 

I have a list of maintenance data and would like to create the graph shown below. Is it doable at Power BI, if so, how can I do?

All the best,

Paris

[Jihwan_Kim · Accepted solution]

Maintenance =

CALCULATE (

SUM ( Data[Capacity] ),

FILTER (

Data,

Data[Start] <= MAX ( Dates[Date] )

&& Data[End] >= MIN ( Dates[Date] )

)

)+0

LINK TO THE PBIX FILE 

[Jihwan_Kim · Accepted solution]

Maintenance =

CALCULATE (

SUM ( Data[Capacity] ),

FILTER (

Data,

Data[Start] <= MAX ( Dates[Date] )

&& Data[End] >= MIN ( Dates[Date] )

)

)+0

LINK TO THE PBIX FILE 

[paris · Accepted solution]

Hello Jihwan Kim

Thank you so much for your reply. I am sorry for keeping changing my comments. 

It worked perfectly when my data is monthly basis.  

My other data is daily baisis and I tried to use your famular again but it did not work.
I will repost it separately as people may find it very useful. 

All the best,

Paris

[Ashish_Mathur]

Hi,

You must transform your data into a 3 column one - Factory, Capacity and Date.  Please follow the steps here - Generating Rows by Month for Date Ranges in Power Query.

[paris]

Hello Ashish,

Following instructions, I added three columns. When I try to apply changes, the following error is shown.

OLE DB or ODBC error: [DataFormat.Error] We couldn't convert to Date.. 

Where should I check?

All the best,

Paris

[Ashish_Mathur]

Hi,

Go through each step in the Query Editor and stop at the one which returns an error.  Ensure that you have copied the correct M code from the Blog article i shared with you.