- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to create a calculated column with 2 condition
Hi everyone!
I want to set up a Calculated column which help me identify "high transfer" and "low transfer"
If "Average Transfer Times" is greater than 30 and "# of Calls" is greater or equal to 15
the Column shows" High Transfer"
If "Average Transfer Times" is less than 3 and "# of Calls" is greater or equal to 50
the Column shows" Low Transfer"
How can I create this calculated Column?
Thanks in advance!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @njxfoster
For your question, here is the method I provided:
Here's some dummy data
Create a column
Transfer Type =
IF(
'Table'[Average Transfer Times] >30 && 'Table'[# of Calls] >= 15,
" High Transfer",
IF(
'Table'[Average Transfer Times] < 3 && 'Table'[# of Calls] >= 50,
"Low Transfer",
BLANK()
)
)
Here is the result
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi @njxfoster
For your question, here is the method I provided:
Here's some dummy data
Create a column
Transfer Type =
IF(
'Table'[Average Transfer Times] >30 && 'Table'[# of Calls] >= 15,
" High Transfer",
IF(
'Table'[Average Transfer Times] < 3 && 'Table'[# of Calls] >= 50,
"Low Transfer",
BLANK()
)
)
Here is the result
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi, @njxfoster
Try below
Column=
Switch (
True (),
Tablename[Average Transfer Times]>30 && tablename[# of Calls]>=15,"High transfer",
Tablename[Average Transfer Times]<3 && tablename[# of Calls]>=50,"low transfer")
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Subject | Author | Posted | |
---|---|---|---|
07-01-2024 10:29 AM | |||
06-13-2024 12:17 AM | |||
01-17-2024 11:27 PM | |||
11-14-2023 05:09 AM | |||
03-19-2024 12:18 AM |
User | Count |
---|---|
13 | |
10 | |
8 | |
8 | |
5 |
User | Count |
---|---|
13 | |
12 | |
11 | |
9 | |
9 |