Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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 @DaveBFT.
Maybe you can check below document to know more about CRM status code:
Default status and status reason values
Regards,
Xiaoxin Sheng
HI @DaveBFT.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
77 | |
73 | |
58 | |
35 | |
31 |
User | Count |
---|---|
99 | |
57 | |
56 | |
46 | |
40 |