Forum Discussion

Helper I

6 years ago

How to find Max in group without using ALLEXCEPT

Hello, I want to find latest date for different areas. I have table: Date; AreaId; Other Values When I use newcolumn = CALCULATE(MAX(myTable[Date]);ALLEXCEPT(myTable;myTable[AreaId])) visual...

Need Help

Kiniaczek

Helper I

6 years ago

After this step I wanted to use IF, compare Date with MaxDateColumn value, get one of other columns value if true and BLANK() when false. After that use average on table visualization. But with measure I'm not able to compare measure and column in IF statement...

Now I completely don't know what to do 😞

I thought it could be possible to use ALLSELECTED to not remove filters and than group by AreaId.