Forum Discussion
Helper VCreate graph by start , end date
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
- Maintenance =CALCULATE (SUM ( Data[Capacity] ),FILTER (Data,Data[Start] <= MAX ( Dates[Date] )&& Data[End] >= MIN ( Dates[Date] )))+0
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
5 Replies
- Ashish_Mathur
Super User
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.
parisHello 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.
- Jihwan_KimMaintenance =CALCULATE (SUM ( Data[Capacity] ),FILTER (Data,Data[Start] <= MAX ( Dates[Date] )&& Data[End] >= MIN ( Dates[Date] )))+0
- paris
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
