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

Jihwan_Kim's avatar
Jihwan_Kim
Super User
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
    Helper V
    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