Calculate Median and MAX row wise in Calculated Columns

[Krishnan_47]

Hi All,

I have a table as following:

Col 1	Col 2	Col 3
10	1	30
40	20	80

I need to create two calculated columns. First one to calculate Median and second to calculate MAX. Please note that I do not want to create in a measure. Please find expected result as below:

Col 1	Col 2	Col 3	Median	Max
10	1	30	10	30
40	20	80	40	80

[amitchandak · Accepted solution]

@Krishnan_47 , Try new columns like

MedianX({[Col1], [Col2], [Col3]},[value])

Maxx({[Col1], [Col2], [Col3]},[value])