Forum Discussion

AO1's avatar
AO1
Frequent Visitor
2 years ago
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...
Dataflows
Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    2 years ago

    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")

     

slorin's avatar
slorin
Icon for Super User rankSuper User
2 years ago

Hi,

Power Query solution :

let
Source = YourSource,
Group = Table.Group(Source, {"Parameter"}, 
  {{"Data", each _, type table [Parameter=text, Treatment=text, Score=number]},
   {"New_Column", each _{[Treatment="CON"]}[Score], type number}}),
Expand = Table.ExpandTableColumn(Group, "Data", {"Treatment", "Score"}, {"Treatment", "Score"})
in
Expand

Stéphane 

  • AO1's avatar
    AO1
    Frequent Visitor
    2 years ago

    slorin, thank you!