Number of project per Week

[DenisCh]

Hi, I am new in  Power Bi environment and I have some trouble with creation a new vizualization.

I need to show in chart, number of open project from this week til 8 weeks ago. This means I need to show how many projects are opened this weeks, how many was opened previous weeks etc. Problems is that I don´t know how do this, because one project could be opened during all period I need to show. In table projekt I have field creationDate and field LastChangeDate, so this is mean LastChangeDate = EndDate when Project has status Finished. 

I don´t know if this problem could be realized as a measure or as a calculated field. I created a table Weeks where I have all 8 weeks from know to past but I don´t know how to connect it with table Projekt.

Can anybody know how to do this?

[Anonymous · Accepted solution]

Hi @DenisCh.

If you can please share some sample data to test.
If you want to calculate count of specific date range, you can refer to below link:

dax - how to count open tickets

Regards,

Xiaoxin Sheng

[DenisCh]

Thank you very much for your help. It helps me to understand CountAX function, so I change it for my requirements.

[Greg_Deckler]

See these similar threads and see if they help:

https://community.powerbi.com/t5/Desktop/Determine-if-date-is-between-2-dates/td-p/208925

https://community.powerbi.com/t5/Desktop/Calculate-number-of-calls-open-based-on-2-date-fields-call-...