Hi, how can I calculate median for each date for item Gross profit without using Data Load editor and creating new table?
I have table:
trans_no Unit_price Unit_cost Qantity Date
transactionA $2 $1 5 2020.01.01
transactionA $4 $2 1 2020.01.01
transactionB $5 $2 2 2020.01.01
transactionC $10 $6 1 2020.01.02
So I want to create a measure which calculates Item GP median. In this example it will be $1
$1, $1, $1, $1, $1, $2, $3, $3 $4