Weighted median - ageing/inv. value

[Anonymous]

Hi all,

I am trying to created Weighted median where value is ageing and weight is the invoice value. 

for example:

customer	ageing	inv amount
A	-22	213,801.13
A	12	142,515.40
A	41	125,303.17
A	68	120,897.10
A	101	155,874.76
A	109	165,717.30
A	158	185,183.65
A	173	179,651.59
A	213	136,749.72

[v-easonf-msft]

Hi, @Anonymous 

You can check if the solutions in this thread help.

Weighted median as a measurement in DAX 

Best Regards,
Community Support Team _ Eason

[Anonymous]

Hi, thanks for the link I am actually using one formula from the disscusion but the DAX is very slow. I would love to create the formula some how in PQ but could not find anything as well.