Solved: DAX Function CALCULATE in Power Query

moldfield · ‎02-03-2020

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[Group]))

Just finding the highest value for each unique value in "Group". As the function is in DAX I cannot use it in power query and need help "translating" it.

Thank you for your help.

Anonymous · ‎02-03-2020

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'.

View solution in original post

Anonymous · ‎02-03-2020

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'.