Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good morning as I can do this formula in POWER BI?MIN(MAX($R$3+($D5+F$4)*$R$4+$R$5*E5;0); 5000)*$E5*SI($D5+F$4 <2;0;1) I appreciate the support
Solved! Go to Solution.
Hello @HECTOR,
You will most likely convert your Excel expression to DAX or M, but how you rewrite it will depend on how your data is viewed. So if you still have problems with this, and need a little help with it, please post some sample data.
Bless you
Sturla
@HECTOR ,Can you share sample data and sample output in table format?
Good morning as I can do this formula in POWER BI?MIN(MAX($R$3+($D5+F$4)*$R$4+$R$5*E5;0);5000)*$E5*SI($D5+F$4 <TM 2;0;1) I appreciate the support.
The formula expressed in the upper midwiser is an excel function where the function of the minimum and the maximum is performed whose main objective is that the maximum value is 5,000.00 otherwise it will take the value will be made a multiplication by one and take the value of E5 if E5 is greater than 5,000.00 the value will be 5,000.00 if it is less than 5,000.00 will take the lowest value not and could perform it in powerbi since if it is less than 5,000.00 it will take the lowest value not and could perform it in powerbi since if it is less I use max only allows me to perform one column, and I need to perform the operations that are within the parentesis and apply the minimum and maximum fume.
Hello @HECTOR,
You will most likely convert your Excel expression to DAX or M, but how you rewrite it will depend on how your data is viewed. So if you still have problems with this, and need a little help with it, please post some sample data.
Bless you
Sturla
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |