cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GRikerWillig
Regular Visitor

Changing a Calculated Column from Text to Integer

Hello all,

Try and create some conditions within my data using calculated columns, but I've run into some issues. I'm created a few Conditional columns that I'm then trying to tie all back together to get 1 value IF and only if all of the conditions are met. However, I then need to convert that value back to an integer and it's proving complicated. Has anyone encountered anything like this before? 

My calculations are as follows:
 
PW STATUS CALC = IF('Opps'[Status]="Open",'Opps'[PW Rev],"")
 
PW Opp Status Calc = IF('Opps'[Opportunity Status]="In Process",'opps'[PW Rev],IF('Opps'[Opportunity Status]="Waiting for Approval",'opps'[PW Rev],IF('Opps'[Opportunity Status]="",'opps'[PW Rev])))
 
PW Sales Stage Calc = IF('Opps'[Sales Stage]="3-Development",'opps'[PW REV],IF('Opps'[Sales Stage]="4-Validation",'opps'[PW REV],IF('Opps'[Sales Stage]="5-Delivery",'opps'[PW REV])))
 
PW Confidence Calc = IF('Opps'[Confidence (%)]="100",'Opps'[PW Rev],IF('Opps'[Confidence (%)]="90",'Opps'[PW Rev],IF('Opps'[Confidence (%)]="75",'Opps'[PW Rev],IF('Opps'[Confidence (%)]="50","",IF('Opps'[Confidence (%)]="25","",IF('Opps'[Confidence (%)]="10","",IF('Opps'[Confidence (%)]="0","")))))))
 
PW Opp Status/Status/Sales Stage = 'Opps'[PW STATUS CALC]='Opps'[PW Opp Status Calc] && 'Opps'[PW Opp Status Calc]='Opps'[PW Sales Stage Calc] && Opps[PW STATUS CALC]='Opps'[PW Confidence Calc]
 
PW ACTUAL REV = IF('Opps'[PW Opp Status/Status/Sales Stage]="TRUE",'Opps'[PW Rev],"")
 
The ultimate goal is to transform the value in PW ACTUAL REV to a number so I can complete additional mathematical calculations against it in my dashboard.
Any direction you can provide would be greatly appreciated, I'm out of ideas.
Thanks so much!
3 REPLIES 3
V-lianl-msft
Community Support
Community Support

Has the problem been solved? If not, please let me know.

V-lianl-msft
Community Support
Community Support

I suggest you use BLANK() instead of "" and confirm that each column with number data created is in number format.

If the problem persists,Please provide a sample pbix with dummy data.

parry2k
Super User
Super User

@GRikerWillig I would recommend paste sample data and expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490






Did I answer your question? Mark my post as a solution.

Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.