Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi Team,
I am currently trying to do a simple count of opportunities, but first I want to decipher the "statuscode" column. Currently the values are random numbers such as "4", "969760004", "1" etc... These will be translated as "won", "lost", "pending etc.. I'd like to know if anyone knows where to find the records or tables in dynamics that hold the answer to this.
Thanks in Advance.
Solved! Go to Solution.
HI @Anonymous.
Maybe you can check below document to know more about CRM status code:
Default status and status reason values
Regards,
Xiaoxin Sheng
HI @Anonymous.
Maybe you can check below document to know more about CRM status code:
Default status and status reason values
Regards,
Xiaoxin Sheng
Thanks! this was helpful, I had some custom codes inthere but ended up using this to make a new table with the status code and status reason which has given me the desired effect.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |