Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 Mar...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

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