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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Laur1987
Frequent Visitor

help variable values

Hi.

I have a project. A perfum store. The client wants to forecast the profits by the price of perfums. The price of perfums depends by the quantity of Ethanol and Perf Oil. How I can make that?

I made the calculator with slicer. (see attach) calculator.pngBut I have to do the forecast now. Like in example below there is the production costs which included a static price of the perfume like R55. PRICE PERFUM.png

PRODUCTION.png

So I need the price to be variable for this dashboard. When I change the price in the total bottle cost, to change the production cost. I tried with lookupvalue because I don t have relationship but is not working.

 

Thanks in advance.

@amitchandak @lbendlin @Greg_Deckler @Ashish_Mathur 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.