Budget-Sales Analysis

[Anonymous]

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

[amitchandak]

@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