Forum Discussion
Maximize a function in DAX
Hello all, Do you know if we can with DAX crete maximize or minimize functions based on conditions? I´ve tried everythin, and i looked in Internet and i didn´t found anything. I want to f...
Hi Anonymous
If you want to get the maximize/minimize value from condition, I think you can convert this formula and use this condition as the filter.
For example:
Original= IF(Table[Column1]>0,max(table[Amount]),0) ↓ New= Calculcate(max(table[Amount]),FILTER(ALL(Table),Table[Column1]>0))
If above not help, can you please provide some sample data?
Regards,
Xiaoxin Sheng
Hi Anonymous
If you want to get the maximize/minimize value from condition, I think you can convert this formula and use this condition as the filter.
For example:
Original= IF(Table[Column1]>0,max(table[Amount]),0) ↓ New= Calculcate(max(table[Amount]),FILTER(ALL(Table),Table[Column1]>0))
If above not help, can you please provide some sample data?
Regards,
Xiaoxin Sheng