One bar graph combining different dates

[alevandenes]

Hi all,

I have one fact table 

- incident #

- creation date

- completion date

I need to build a bar graph that for each day tells me how many new incidents we had, how many were completed and how many are still open (completion date is empty). Somehow i am stuck with this.

Can someone help me?

Kind regards,
Alessandra

[v-shex-msft · Accepted solution]

Hi @alevandenes,

It sounds like a common data range analysis requirement, please take a look at the following link 'start date', 'end date' part to create a formula to analysis:
Before You Post, Read This  

In addition, you can also try to create a new table to expand table records for analysis:

Spread revenue across period based on start and end date, slice and dase this using different dates 

Regards,

Xiaoxin Sheng

[amitchandak]

@alevandenes , refer to my HR blog on a similar topic

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...

or video -https://www.youtube.com/watch?v=e6Y-l_JtCq4