Need to extend table from monthly plan to daily plan

[u2aziz]

https://1drv.ms/f/s!Au2cwqE4NfwmhIIlx07c6m5s_TiUyA 

Hello friends 

I need to extend monthly plan to daily plan
DAX formula need to write

File was attached 

For exaple we sell in july 5000 quantity

I need the result for daily 166 quantity

Thanks for all

[amitchandak · Accepted solution]

@u2aziz ,

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

With month create a date. then  you can have

Start Date = eomonth([Date],-1)+1

end Date = eomonth([Date],0)

these can also help once you have two dates

Between Dates - Dates between
Tables
https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b
https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2

Measure way

https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-o...