Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Date issue

Hi,  I am struggling with a painful date issue ... I have a dataset made of  - project number - date of creation (day-month-year) - date of closing (day-month-year) I would like to analyze, per ...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi, 

    Thanks you both for your answers. I finally find a way to cope with this situation with something closed to what you suggested v-yalanwu-msft 

    As I am working with an excel sheet as data source, I set a new tab with 1 period of time per line, and count (with formulas) how many projects opened and how many closed. Then I visualize these new fields in Power Bi. It works well but I lost all other project caracteristics. I guess your solution enable you to keep filtering on project type, etc and still get the monthly count. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, 

Thanks you both for your answers. I finally find a way to cope with this situation with something closed to what you suggested v-yalanwu-msft 

As I am working with an excel sheet as data source, I set a new tab with 1 period of time per line, and count (with formulas) how many projects opened and how many closed. Then I visualize these new fields in Power Bi. It works well but I lost all other project caracteristics. I guess your solution enable you to keep filtering on project type, etc and still get the monthly count.