Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

Anonymous
Not applicable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Multiple IF
02-22-2019
04:38 AM
Hola;
Necesito segmentar datos en 4 o 5 categorías diferentes (<10, >10, >15, >30), doy un ejemplo sencillo:
Persona Edad SEGMENTACION
A 5 <10
B 29 >15
C 13 >10
D 55 >30
E 14 >10
Actualmente uso:
Antigüo = IF(BajadaVBobina[EDAD]<10,"<10",IF(BajadaVBobina[Antiguedad]<15,"<15",">15"))
Pero necesito realizar más condiciones y no me lo permite.
Gracias
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2019
06:39 AM
You could use nested IF statements, but I would use a SWITCH(TRUE()...) statement.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-24-2019
09:20 PM
Hi @Anonymous
Try below formula:
Column = IF ( Table3[Edad] < 10, "<10", IF ( Table3[Edad] > 10 && Table3[Edad] < 15, ">10", IF ( Table3[Edad] > 15 && Table3[Edad] < 30, ">15", ">30" ) ) )
or
Column 2 = SWITCH ( TRUE (), Table3[Edad] < 10, "<10", Table3[Edad] > 10 && Table3[Edad] < 15, ">10", Table3[Edad] > 15 && Table3[Edad] < 30, ">15", ">30" )
Regards,
Cherie
Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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
02-22-2019
06:39 AM
You could use nested IF statements, but I would use a SWITCH(TRUE()...) statement.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: Power BI Cookbook Third Edition (Color)
DAX is easy, CALCULATE makes DAX hard...

Helpful resources
Recommendations
Subject | Author | Posted | |
---|---|---|---|
12-29-2024 12:09 PM | |||
01-13-2025 03:10 PM | |||
03-05-2025 07:05 AM | |||
01-07-2025 01:51 PM | |||
09-05-2024 01:55 PM |
Featured Topics
Top Kudoed Authors (Last Month)
User | Count |
---|---|
122 | |
107 | |
85 | |
52 | |
46 |