Revenue-Budget.xlsx (25.9 KB)
In the Attached Excel sheet i have a table With Year, Week, Type (Revenue or Budget) and Value.
There is no date Field in the table, only weeks and year, and so far no
Is it to add a column and calculate date for the last day in the week, and Connect this date Field to the date table ?
I like to calculate totals of Budget and Revenue for each year, quater, month, week, last week, compare it With last year.
DateTable. Any idea how to handle this scenario, With an example ?