Forum Discussion
Budget-Sales Analysis
Hi guys,
I am new in this group as well as new to Power BI. I want to ask how to distribute monthly store sales budget values per day based on sales data of last two years for month of April and March. I have budget table which have three columns ( Salespoints, Date,Budget) the date is for the months of March and April 2022. And I have sales table which also have three columns ( Salespoints, Date, Sales) - here date refers to only two months March and April for year 2020-2021. The month in questions are April and May.
Any guidance will highly be appreciated
1 Reply
Anonymous , refer
Power BI Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798
same can applied to month level
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
