Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello Community. I have an application getting data written to sharepoint. I want to count the number of users signed up today(). I have something like this. Though with errors.
Number of Users Added Today=
VAR COuntTOdayUsers =
CALCULATE(COUNT('Users Information'[Title]
'Users Information'[Created] =TODAY()
)
RETURN
COuntTOdayUsers
Please assist
Solved! Go to Solution.
@Datagulf Try:
Number of Users Added Today=
VAR __Table = FILTER('Users Information',[Created] = TODAY())
RETURN
COUNTROWS(__Table)
@Datagulf Try:
Number of Users Added Today=
VAR __Table = FILTER('Users Information',[Created] = TODAY())
RETURN
COUNTROWS(__Table)
User | Count |
---|---|
84 | |
76 | |
74 | |
49 | |
39 |
User | Count |
---|---|
114 | |
56 | |
51 | |
42 | |
42 |