Count of projects on each server

[axy5093]

Hi, Am new to PowerBi and just trying to get familiar, so i have a project data which is in this format.

How do i calculate New Projects in Past 7 Days and count of projects on each server. 

It would be great if anyone can guide me to any tutorial of DAX basics 

Thanks.

[Anonymous · Accepted solution]

New Project in Past 7 = 
VAR FilterDate = Today() - 7
RETURN
CALCULATE(
	CountRows('YourTable'),
	'YourTable'[Created Date] >= FilterDate
)

This assumes each line is a project without any duplications you don't want counted.

As for project count, if you create a matrix visual, place the ServerName as the rows and the Project Name as the value.  You can then instruct Power BI, using the dropdown on the field name, to do a distinct count.  It will effectively measure it the same as:

ProjectCount = DISTINCTCOUNT('YourTable'[Project Name])

[axy5093]

@Anonymous Thank you this does the job!