topic Re: Need to extend table from monthly plan to daily plan in DAX Commands and Tips

topic Re: Need to extend table from monthly plan to daily plan in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-extend-table-from-monthly-plan-to-daily-plan/m-p/2754692#M85115 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="438838" data-lia-user-login="u2aziz" class="lia-mention lia-mention-user">u2aziz</a> ,</P> <P> </P> <P>Power BI Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): <A href="https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798" target="_blank">https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798</A></P> <P> </P> <P> </P> <P>With month create a date. then  you can have</P> <P> </P> <P>Start Date = eomonth([Date],-1)+1</P> <P> </P> <P>end Date = eomonth([Date],0)</P> <P> </P> <P> </P> <P>these can also help once you have two dates</P> <P> </P> <P>Between Dates - Dates between <BR />Tables <BR /><A href="https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b" target="_blank">https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b</A><BR /><A href="https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2" target="_blank">https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2</A></P> <P>Measure way</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785</A></P> <P> </P> Thu, 08 Sep 2022 08:36:29 GMT amitchandak 2022-09-08T08:36:29Z Need to extend table from monthly plan to daily plan https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-extend-table-from-monthly-plan-to-daily-plan/m-p/2754367#M85090 <P><A title="File" href="https://1drv.ms/f/s!Au2cwqE4NfwmhIIlx07c6m5s_TiUyA" target="_self">https://1drv.ms/f/s!Au2cwqE4NfwmhIIlx07c6m5s_TiUyA</A> </P><P> </P><P>Hello friends </P><P>I need to extend monthly plan to daily plan<BR />DAX formula need to write</P><P>File was attached </P><P>For exaple we sell in july 5000 quantity</P><P>I need the result for daily 166 quantity</P><P> </P><P>Thanks for all</P> Thu, 08 Sep 2022 06:03:50 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-extend-table-from-monthly-plan-to-daily-plan/m-p/2754367#M85090 u2aziz 2022-09-08T06:03:50Z Re: Need to extend table from monthly plan to daily plan https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-extend-table-from-monthly-plan-to-daily-plan/m-p/2754692#M85115 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="438838" data-lia-user-login="u2aziz" class="lia-mention lia-mention-user">u2aziz</a> ,</P> <P> </P> <P>Power BI Distributing/Allocating the Monthly Target(Convert to Daily Target): Measure ( Daily/MTD): <A href="https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798" target="_blank">https://community.powerbi.com/t5/Community-Blog/Power-BI-Distributing-Allocating-the-Monthly-Target-Convert-to/ba-p/1657798</A></P> <P> </P> <P> </P> <P>With month create a date. then  you can have</P> <P> </P> <P>Start Date = eomonth([Date],-1)+1</P> <P> </P> <P>end Date = eomonth([Date],0)</P> <P> </P> <P> </P> <P>these can also help once you have two dates</P> <P> </P> <P>Between Dates - Dates between <BR />Tables <BR /><A href="https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b" target="_blank">https://amitchandak.medium.com/dax-get-all-dates-between-the-start-and-end-date-8f3dac4ff90b</A><BR /><A href="https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2" target="_blank">https://amitchandak.medium.com/power-query-get-all-dates-between-the-start-and-end-date-9ad6a84cf5f2</A></P> <P>Measure way</P> <P><A href="https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785" target="_blank">https://community.powerbi.com/t5/Community-Blog/How-to-divide-distribute-values-between-start-date-or-end-date/ba-p/1503785</A></P> <P> </P> Thu, 08 Sep 2022 08:36:29 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Need-to-extend-table-from-monthly-plan-to-daily-plan/m-p/2754692#M85115 amitchandak 2022-09-08T08:36:29Z