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, Matthia...
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

     

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?