Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I have one calculator in Excel, I want to transfer it to PowerBI. I want to make new table with 2 columns: QTY and Revenue(exponent) with list from 1 to 20000, but i want the user to be able to change the 20000 number. I also want the user to be able to change Min, Max and the coefficient for exponent.
So, I want to make one table with 2 columns, variable rows and variables in formulas, which USER can change directly in report(not in PowerQuery Editor). Here are 2 pictures of my calculator and how I have made it in Excel:
A3 = IF(A2="";"";IF((A2-1)<=0;"";(A2-1)))
B3 = IF(A3="";"";($D$2+($D$3-$D$2)*(1-(A3-1)/$D$4)^$D$1))
In Power BI this is called "What-If parameters". Note that your range can only have up to 1000 values, so if you want to specify from 1 to 20000 it would have to be in increments of 20.
User | Count |
---|---|
99 | |
86 | |
80 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |