Forum Discussion

jopezzo's avatar
jopezzo
Icon for Helper I rankHelper I
7 years ago
Solved

How to filter a table based on a column's highest value

Hi,   I am trying to calculate the total quantity by Quality from a table called "Data", but filtering on the highest value in Period (in this case, 201906).  The purpose is to calculate the varian...
  • Anonymous's avatar
    Anonymous
    7 years ago
    Please use the same link as above.

    Best
    D.
Anonymous's avatar
Anonymous
Not applicable
7 years ago
Again, please resist the temptation to do it in DAX. Use Power Query because this is the right tool for the job.

Best
D.