Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am trying to get a 0 or 1 indicator if a value falls one standard deviation outside the mean for a variable period of time that can be changed. I know this can be done for a column, but can it be done for a measure?
Can provide more detail if necessary
You may create a measure like below:
Measure_ = IF(MAX(Table2[Value])>[Standard Deviation],1,0)
Regards,
This response doesn't allow me to use a measure as Table 2[Value], it needs a column. Is there a way to use a measure instead of a column here?
You may try below measure.If it is not your case,please share some sample data and expected output which could reproduce your scenario.
Measure_ = IF([measure1]>[Standard Deviation],1,0)
Regards,
I think I was unclear, this did answer my initial question. However, the actual solution that I need would be comparing the variance of a measure over time to the standard deviation.
Example:
Standard Deviation of Measure = 14.7%
Measure Yesterday = 80% (this measure can be looked at every day, by week, by month, and by year)
Measure Last Week: 85.4%
I want to see if the change in the measure day over day, week over week, month over month > the standard deviation for that period, and if so flag 1.
Let me know if this makes sense.
I really appreciate your help!
It seems you need to get the measure of last year,week.Below are some reference for you.
https://community.powerbi.com/t5/Desktop/Variance-between-two-measures/m-p/588970#M279325
Regards,
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |