Forum Discussion
Divide / multiply by a fixed figure
My customer has a monthly figure 300000 and it needs to be divided by a coloumn which shows how many working days are in that month. Literally 300000 / working days in a month = Daily whatevers ...
parry2k
Super User
Super UserAnonymous assuming your workingdays formula is correct:
you can do this:
WorkingDays =
VAR workingDays= CALCULATE(sum('date'[IfWorkDay]))
VAR fixedValue = 30000
RETURN
DIVIDE( fixedValue, WorkingDays)
For some reason this is multiplying not dividing?
I've taken the variable: fixedvalue to 1 and it multiplies itself by the amount of working days. (Working days are showing correctly).
- parry2k
Anonymous can you share the output of your result, it is very hard to figure out what is going on, and if possible provide the sample data .
As you can see, I have adjusted the value to 1 and I've asked it to divide 1 by the amount of working days in the month. Instead it's multiplied it?
- parry2k
Anonymous I just did the same thing and it works fine, can you share your pbix file or provide the sample data your are working on so that I can take a look