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