Create a daily table based on 'from' and 'to' columns

[Mumin192]

Hello,

I have campaign table with campaign name, total cost, start date, and number of days

I want to convert it into a daily table in order to know the daily cost

so if one campaign starts on 1st-July and lasts for 10 days, it would create a table with 10 rows (July-1, July-2, July-3,....) with campagin name and daily cost by dividing total cost by number of days

Solution can be in Power Query or Dax

Thanks

[amitchandak · Accepted solution]

@Mumin192 , On of three approaches should help

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