Forum Discussion

moldfield's avatar
moldfield
Frequent Visitor
6 years ago
Solved

DAX Function CALCULATE in Power Query

Hello,   I need a simple function that I know how to create in DAX but I cannot figure out how to implement it in Power Query. It is:   Column = CALCULATE(MAX([Number]),ALLEXCEPT(Table,Table[Gro...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi,

     

    I don't really know what the DAX Expression means, but if you want to find the highest value for each unique value in "Group", then:

    • Go to the Query Editor
    • Right-click the column 'Group' in 'Table'
    • Select the Option 'Group by...'
    • A new message box should pop up, in this: Select the operation 'Max' and the column 'Number'Now for each unique value in 'Group', there is a corresponding maximum value from 'Number'.
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

I don't really know what the DAX Expression means, but if you want to find the highest value for each unique value in "Group", then:

  • Go to the Query Editor
  • Right-click the column 'Group' in 'Table'
  • Select the Option 'Group by...'
  • A new message box should pop up, in this: Select the operation 'Max' and the column 'Number'Now for each unique value in 'Group', there is a corresponding maximum value from 'Number'.