Forum Discussion

paris's avatar
paris
Helper V
5 years ago
Solved

Create 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?   ...
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

     

    Maintenance =
    CALCULATE (
    SUM ( Data[Capacity] ),
    FILTER (
    Data,
    Data[Start] <= MAX ( Dates[Date] )
    && Data[End] >= MIN ( Dates[Date] )
    )
    )+0
     
     
     
     
  • paris's avatar
    paris
    5 years ago

    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

  • paris's avatar
    paris
    Helper V
    5 years ago

    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's avatar
      Ashish_Mathur
      Super User
      5 years ago

      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.