Forum Discussion
Status Changed for year
Greetings, I have the following table in Power BI and I need to calculate how many changes of status there were per year
| User | YEAR | STATUS |
| 1 | 2013 | A |
| 1 | 2014 | B |
| 1 | 2015 | B |
| 1 | 2016 | B |
| 2 | 2013 | A |
| 2 | 2014 | B |
| 2 | 2015 | B |
| 2 | 2016 | A |
| 3 | 2013 | A |
| 3 | 2014 | A |
| 3 | 2015 | B |
| 3 | 2016 | B |
For Example for year 2014 there were 2 changes of state. how can i represent that in a dax formula
Hello Anonymous
Something like this should work for you
Status Changes = DISTINCTCOUNT ( YourTable[STATUS] )Then pull Year from the table and this measure into a visual.
1 Reply
Hello Anonymous
Something like this should work for you
Status Changes = DISTINCTCOUNT ( YourTable[STATUS] )Then pull Year from the table and this measure into a visual.