Graph using cumulative Count

[PBI5851]

Hello ,

 I am trying to develop a graph to display the cumulative Open count of Jobs on a line graph. Below is the data i have, the first three columns are in the table, the fourth (Open Flag) is a new column i created using an IF condition. (If status = Open then 1 else 0). 

The JobStart is joined to the Date on the Datetable . I thought of doing the calculated column so I can do a sum of that field .

The pbix file is here.  https://drive.google.com/file/d/1_jW3AVMl0vNDxcELjvKo033Oo81AnjDq/view?usp=sharing

But the graph isnt showing as expected. Any recommendations on how to fix this please. 

[PBI5851]

Sorry.. Updated link .. https://drive.google.com/file/d/1_jW3AVMl0vNDxcELjvKo033Oo81AnjDq/view?usp=sharing

[Icey]

Hi @PBI5851 ,

I don't have access to your file. Please give me access.

Best regards

Icey

[amitchandak]

@PBI5851 , file not found.

See if  my blog can help a bit :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...