Forum Discussion
To flag latest value per category
Hey guys, I have this DAX column but want to transfer it to PQ. Can you help ? Latest modified = var latest_date = CALCULATE ( MAX ( Statistics[Modified DateTime] ), ALLEXCEPT ( Statistics, St...
Use Group By on the ActionKey column, select the Advanced radio button and you can add a column for the max Modified DateTime and also include all rows. Expand the resulting Table column and you can add a conditional column comparing the Modified DateTime to the max date time column
Use Group By on the ActionKey column, select the Advanced radio button and you can add a column for the max Modified DateTime and also include all rows. Expand the resulting Table column and you can add a conditional column comparing the Modified DateTime to the max date time column