Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
rifaymars
Frequent Visitor

Make a table from variables + exponent formula in PBI

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))

 

rifaymars_0-1703159406962.pngrifaymars_1-1703159415938.png

 

1 REPLY 1
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.