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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
hluque
Frequent Visitor

Create price calculator

Hello!

 

I need to create a dashboard to calculate the price of the services that my company is offering. The values to take into account are:

 

1. Price per working day of each of the employee roles that will be involved.

2. Any discount that might be applied.

3. The number of working days that will be necessary.

 

I already have bulit the information needed for point 1 and will use a What If parameter for point 2.

 

My question is: how can I implement a slicer or a field where the number of working days can be entered and multiplied by the price of role per day? For example, the role of System Engineer costs 200$ a day and if I enter that it will be necessary for 30 days, the total amount shown should be 6000$.

 

Thanks!

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

Would probably want to use What If parameters for those as well.

 

That being said, you may not have the right tool for the job, something like PowerApps might be a better fit.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
v-yuta-msft
Community Support
Community Support

Hi hluque,

 

Create a waht-if parameter which is ranged from 0~30, then create a measure in the table useing DAX as this pattern: 

parameter[parameter] * 30

Regards,

Jimmy Tao

Thanks for the suggestion too!

Greg_Deckler
Super User
Super User

Would probably want to use What If parameters for those as well.

 

That being said, you may not have the right tool for the job, something like PowerApps might be a better fit.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks Greg, I think you are right regarding the tool, I'll consider to use another one.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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