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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Syndicate_Admin
Administrator
Administrator

Cómo manejar valores nulos numéricos o en blanco

Construyo una tabla visual donde algunos valores en algunos días tienen valores nulos o en blanco. Por favor avise. Gracias de antemano.

Accepted = if(isblank(SUM(Chat_Snowflake[ACCEPTED Original])),0,SUM(Chat_Snowflake[ACCEPTED Original]))

o

Accepted = if(SUM(Chat_Snowflake[ACCEPTED Original]=0,0,SUM(Chat_Snowflake[ACCEPTED Original])

akosiRandy_0-1692803423935.png

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

using Accepted = coalesce(sum(Chat_Volume[ACCEPTED Original]),0) funciona en los elementos visuales de una tabla, pero no en la matriz (ver arriba). Gracias.

Syndicate_Admin
Administrator
Administrator

@kpost de alguna manera, funciona en Table Visual, pero no en Matrix Visual Hmmm

akosiRandy_0-1692807018732.png

Syndicate_Admin
Administrator
Administrator

¿Qué estás tratando de hacer exactamente con los valores en blanco?

¿Parece que tal vez quieres que se muestren como ceros?

Aceptado = COALESCE(SUMA(Chat_Snowflake[ACEPTADO Original]), 0)

Consejos mediocres de Power BI, pero son gratis //

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors