Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Everyone, I'm brand new to DAX and i'm trying to calculate SD. Can anyone help me out? Below are the details.
I have a dataflow setup from a Database that puts the below columns in a table. The "Move_time" column and the "crane_id" column. The "Move_time" column is in a date format.
the table looks like this.
Move_time | Crane_ID
01:09 151
01:15 151
01:30 120
02:09 120
02:10 151
I created a custom measure called Count MoveTime = COUNT(table[Move_time]) that I can use to count how many times each crane moved, so I can recap easily in reports. A recap would look like this.
Crane_ID | Count MoveTime
151 603
120 201
Since I can't simply run STDEVX.P on the (table[Move_time]) since it's a date, I'm kinda lost. How would I achieve this using the "Count MoveTime" measure?
Solved! Go to Solution.
Hi @jpurdue
It sounds like you want the standard deviation of [Count MoveTime] per crane. Is that right?
If so, you should provide the distinct values of Crane_ID as the first argument, and the [Count MoveTime] measure as the second argument.
For example:
Standard deviation of Count MoveTime per Crane =
STDEVX.P (
VALUES ( table[Crane_ID] ),
[Count MoveTime]
)
Regards,
Owen
ahh that easy huh? THANKS!!!!!!!!
Hi @jpurdue
It sounds like you want the standard deviation of [Count MoveTime] per crane. Is that right?
If so, you should provide the distinct values of Crane_ID as the first argument, and the [Count MoveTime] measure as the second argument.
For example:
Standard deviation of Count MoveTime per Crane =
STDEVX.P (
VALUES ( table[Crane_ID] ),
[Count MoveTime]
)
Regards,
Owen
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
28 | |
22 | |
12 | |
8 |
User | Count |
---|---|
75 | |
52 | |
46 | |
15 | |
12 |