Forum Discussion
Solved
Calculated Table + Add Columns (when filtered by category)
Hi everyone, I do not have the "Financial Estimate" on a daily level (monthly only). So I created a table (Fig. 01) to calculate the daily average based on the estimated value for the current mon...
THPNO80 , Based on what I got, see if these can help
Measure way
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
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzMTables way
https://amitchandak.mediumcom/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
