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")
wdx223_Daniel
Community Champion
Community ChampionDAX:
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")
wdx223_Daniel, you made my day! Your solution not only works, your code is concise and easy to follow. Thank you!