Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi, Iam learning dax .kindly help me in solving -
how can i substract these minimum of each "value" corrsponding to "category" for each "country".
like .
for each Country - for "p" category - value minus minmum(P)
fact table
Thank you
Solved! Go to Solution.
NewColumn=TableName[Value]-MINX(FILTER(TableName,TableName[Year]=Earlier(TableName[Year])&&TableName[Category]=Earlier(TableName[Category])),TableName[Value])
NewColumn=TableName[Value]-MINX(FILTER(TableName,TableName[Year]=Earlier(TableName[Year])&&TableName[Category]=Earlier(TableName[Category])),TableName[Value])