Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
fav_ccc2021
Helper I
Helper I

Encontrar un estado dentro de una tabla

Hola a todos, espero puedan ayudarme,

Tengo un ID dentro de una tabla donde quiero encontrar un estado especifico . Lo quiero dejar como una columna no como medida.

 

Ejemplo

 

fav_ccc2021_0-1728584085447.png

En la tabla donde tengo un ID con multimples estados, busco uno el de "aceptado" en una columna adicional.

 

Desde ya muchas gracias.

1 ACCEPTED SOLUTION
v-xuxinyi-msft
Community Support
Community Support

Hi @fav_ccc2021 

 

Thanks for the reply from lbendlin .

 

The following testing is for your reference.

 

Sample:

vxuxinyimsft_1-1728626178082.png

 

Create a calculated column as follows

AcceptedStatus = 
IF(
    CALCULATE(
        COUNTROWS('Table'),
        'Table'[Estado] = "Aceptado"
    ) > 0,
    "Aceptado",
    BLANK()
)

 

Output:

vxuxinyimsft_2-1728626379614.png

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-xuxinyi-msft
Community Support
Community Support

Hi @fav_ccc2021 

 

Thanks for the reply from lbendlin .

 

The following testing is for your reference.

 

Sample:

vxuxinyimsft_1-1728626178082.png

 

Create a calculated column as follows

AcceptedStatus = 
IF(
    CALCULATE(
        COUNTROWS('Table'),
        'Table'[Estado] = "Aceptado"
    ) > 0,
    "Aceptado",
    BLANK()
)

 

Output:

vxuxinyimsft_2-1728626379614.png

 

Best Regards,
Yulia Xu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lbendlin
Super User
Super User

Sounds good. What have you tried and where are you stuck?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors