Distributing a value throughout months

[anabianco09]

Hi all, I am trying to distribute some values throughout the months of the year, and display it on a column chart (as a line) that uses the date hierarchy from another table on the query.

These values I want to distribute are grouped within a category that has a slicer on the dashboard. 

Any idea how can I proceed with it?

[amitchandak · Accepted solution]

@anabianco09 , Check few ways

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

Between Dates - Dates between

Measure way
Power BI Dax Measure- Allocate data between Range: https://youtu.be/O653vwLTUzM

Tables 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