I want to multiply the cost of multiple items by a mark up value. I can do this for a predetermined fixed number by creating a simply calculated column either in the query editor or in the data view. For example:
New Column = 'Project Hours Booked'[Cost, Reg.] * 2.2
However, the people viewing the dash board (i.e. senior management) that I have created using this column would like to be able to adjust this mark up value without having without having to go back to the data set or the query editor. Is there a way to put a filter or text field on the dashboard which when edited updates the calculation?
So in order to create the slicer, I was going to create a new table with a list of numbers starting at 2.00 and ending in 2.40 (essentially 41 numbers). Obviously I can enter the values manually but I was hoping to be able to generate it using a DAX formula. Can you help?