Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

 

Why is this so hard to do? It's a fixed figure, it hasn't changed in 15years and to have to create a table etc just for 1 calculation of 1 figure seems a bit overkill. I've searched google high and low but it appears to me that unless it's referencable in a table PowerBi won't let you do it. Unless I'm missing something completely obvious (not unrealistic).

 

Thanks in advance.

Need Help

7 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    7 years ago

    Anonymous i didn't understood your question. it should not be very hard. can you share sample data and what you want to achieve as the final result.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Literally

       

      300000 / Workingdays = 

       

      WorkingDays = CALCULATE(sum('date'[IfWorkDay]))

       

      I can't seem to find a way to do this as it wants to reference a field. 30000 doesn't exist in a field it's a static figure.

      • parry2k's avatar
        parry2k
        Icon for Super User rankSuper User
        7 years ago

        Anonymous assuming your workingdays formula is correct:

         

        you can do this:

         

        WorkingDays = 
VAR workingDays= CALCULATE(sum('date'[IfWorkDay]))
VAR fixedValue = 30000
RETURN
DIVIDE( fixedValue, WorkingDays)