Forum Discussion
Solved
New Column or Measure
Hi, I'm new to PowerBi and would really appreciate your help with creating either a new column or new measure. So i have the below table: Parameter Treatment Score A TRT1 10 A C...
DAX:
CalculatedColumn=MAXX(FILTER(Table,Table[Parameter]=EARLIER(Table[Parameter])&&Table[Treatment]="CON"),Table[Score])
Measure=CALCULATE(MAX(Table[Score]),ALLEXCEPT(Table,Table[Parameter]=MAX(Table[Parameter]),Table[Treatment]="CON")
Measure=CALCULATE(MAX(Table[Score]),Table[Parameter]=MAX(Table[Parameter]),Table[Treatment]="CON")
Now, it works. Thanks!