Forum Discussion

Pamicas's avatar
Pamicas
New Member
5 years ago

Help :( - Monthly Budget - Daily

Dear I am making a sales/budget report, and I would like to see the option or way to be able to determine the value of the daily budget according to the monthly budget that each store has and eac...
amitchandak's avatar
amitchandak
Super User
5 years ago

Pamicas , There are couple of ways. I have blog from yearly to daily. But you have similar functions to make it from monthly to daily datesmtd, closingbalancemonth

 

powerbi Distributing/Allocating the Yearly Target(Convert to Daily Target): https://community.powerbi.com/t5/Community-Blog/Distributing-Allocating-the-Yearly-Target-Convert-to-Daily/ba-p/1463290

 

PowerBI Distributing/Allocating the Yearly Target(Convert to Daily Target): Measure ( Daily/YTD): Magic of CLOSINGBALANCEYEAR With TOTALYTD/DATESYTD: https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Yearly-Target-Convert-to/ba-p/1476400

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi amitchandak , what is the difference between the 2 methods ?

    I want to convert a Monthly budget to a Daily budget to do more precise analysis. 

    Do you think I can do it with one of your method ? 

    Sincerly