Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

allocate Budget Month / Day


Hello. I have the (whole) monthly budget always on the 1. day of the month. I need to allocate /spread it evenly to all days of the month. Any Ideas on how to solve that? 

thank you, Matthias

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Anonymous

     

    You may refer to below measure. If it is not your case, please share some sample data for your scenario so that we could help further on it. Attached my sample file for your reference.

     

    Measure =
CALCULATE (
    SUM ( Test[Budget] ) / DISTINCTCOUNT ( 'Calendar'[Date].[Day] ),
    ALL ( 'Calendar'[Date].[Day] )
)

    Regards,

    Cherie

     

3 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous

     

    You may refer to below measure. If it is not your case, please share some sample data for your scenario so that we could help further on it. Attached my sample file for your reference.

     

    Measure =
CALCULATE (
    SUM ( Test[Budget] ) / DISTINCTCOUNT ( 'Calendar'[Date].[Day] ),
    ALL ( 'Calendar'[Date].[Day] )
)

    Regards,

    Cherie

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks !!!

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi Anonymous

     

    Where do you want to allocate it, in the columns of your date table? In a matrix visual with the dates (day level) on the rows?

    Can you show the tables in your data model or share the pbix?