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 find the Maximun value of one parameter that i created (from 0 to 1 plus 1 I.e 1.16%) that makes my Budget - Cost more close to 0.
It could be great if we can add to our datamodels that kind of stuff.
Thank you!!
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
2 Replies
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
I would create an Enter Data query with the values that you want to analyze and then create a column or measure that does your calculation and then plot that. I may not be understanding what you are going for. You can also maybe take a look at the new "What If" parameters that they added to Power BI in August.
