Count active days of each developer using Dax.

[Skon311]

Hello All ,

 I am a beginner in Power BI Desktop. I am trying to build dashboards about developers activity ( LOC ,Churn, Files changed, Files aded ,Files added , Commits, Impact .. ) .

I have generated my own data using Python that lists all commits by each developers and the dates are taken randomly. I would like to create a measure using Dax that counts the number of days within any given time period (Range silder) that an developer was taking any action.

Here is my data table exemple:

My Dashbord : 

Thanks All. 

[jdbuchanan71 · Accepted solution]

@Skon311 

It looks like your [Date] column is a date/time.  You will need a column that is just the active date, then you can do a count measure like:

Active Days = DISTINCTCOUNT(Git_Data_[Active Date])

[Skon311]

thank you @jdbuchanan71 for your response. I have already tried it with active days(only Date) but it doesn't work because the measure returns the same value even when I try several date ranges.

[jdbuchanan71]

@Skon311 

I don't know why that would be.  It's a pretty straight forward calculation.  My example has customer_id but is shouldbe the same for developer.

Can you share your .pbix?

[Skon311]

think I fixed the problem by defining again the date and the fault is also because of the data which is generated is almost equal for the developers.

Yes of course here is the .pbix : 

https://1drv.ms/u/s!Au8vNAEE9U3-oGyp_XkYoMqhuLmU?e=aJHEbE 

if it's wrong im here, thanks

[jdbuchanan71]

Hmm, I am not able to open that file but it sounds like you got it working so no need for me to look at it.

[Skon311]

thank's a lot man!