measure by day

[master_student]

hello everyone,

Hope this finds you well.

I have an excel file that contains the budget by department and by month of date as you can see bellow :

Departement	month of date	budget
finance	01/01/2016	500
Information system	01/02/2016	1000

My objective is to display the budget by day and the sum of budget still the same, like that :

Departement	calendar date	sum (budget) : 500
finance	01/01/2016	500
finance	02/01/2016	500
finance	02/01/2016 ......UNTIL 30/01/2016	500

could you please help me?

Thanks in advance

[swuehl]

Not sure if I understand your request.

Basically, to avoid duplication of facts, don't join, just link the tables.

INPUT:

LOAD * INLINE [

Departement, month of date, budget

finance, 01/01/2016, 500

Information system, 01/02/2016, 1000

];

left join

LOAD DISTINCT

[Month start date] as [month of date]

,[%Date ID]

RESIDENT D_Calendar;

[master_student]

could you send me your email please. I would like to share my app with you. please it's urgent