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. 

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
4 years ago

Hi, Anonymous ;

Congratulations on the solution to your answer,  Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.