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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Syndicate_Admin
Administrator
Administrator

Crear una columna mediana de cálculo

Estimados usuarios avanzados,

Necesito crear una nueva columna "calcular una mediana del valor unitPrc" por el mismo ProdCode, Vendor y ProdType

Por favor, ayude amablemente en una sintaxis DAX.

GRCz_0-1653155558106.png

Gracias.

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

@GRCz

MedianUnitPrice =
VAR _current_prod_code = 'Table'[ProdCode]
VAR _current_vendor = 'Table'[Vendor]
VAR _current_prod_type = 'Table'[ProdType]
RETURN
CALCULATE(
		MEDIAN('Table'[UnitPrc]),
		REMOVEFILTERS('Table'),
		'Table'[ProdCode] = _current_prod_code,
		'Table'[Vendor] = _current_vendor,
		'Table'[ProdType] = _current_prod_type
)


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Informe de presentación – Contoso by SpartaBI


SpartaBI_3-1652115470761.png SpartaBI_1-1652115142093.png SpartaBI_2-1652115154505.png

Full-Logo11.png

View solution in original post

3 REPLIES 3
Syndicate_Admin
Administrator
Administrator

@GRCz

MedianUnitPrice =
VAR _current_prod_code = 'Table'[ProdCode]
VAR _current_vendor = 'Table'[Vendor]
VAR _current_prod_type = 'Table'[ProdType]
RETURN
CALCULATE(
		MEDIAN('Table'[UnitPrc]),
		REMOVEFILTERS('Table'),
		'Table'[ProdCode] = _current_prod_code,
		'Table'[Vendor] = _current_vendor,
		'Table'[ProdType] = _current_prod_type
)


2022-05-19 17_30_22-Re_ Need help on DAX function with measure vs colu... - Microsoft Power BI Commu.png

Informe de presentación – Contoso by SpartaBI


SpartaBI_3-1652115470761.png SpartaBI_1-1652115142093.png SpartaBI_2-1652115154505.png

Full-Logo11.png

Gracias por su ayuda : )

@GRCz mi placer 🙂
Oye, echa un vistazo a mi informe de exhibición:
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Dale un pulgar hacia arriba si te gustó 🙂

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.