Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Create a calculation median column

Dear Power Users,

 

I need to create a new column "calculating a median of UnitPrc value" group by the Same ProdCode, Vendor and ProdType

Please kindly help on a DAX syntax.

 

 

Thank you .

 

Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    Anonymous 

     

    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
)

     


    Showcase Report – Contoso By SpartaBI


          

3 Replies