Forum Discussion
Solved
MEASURE PROBLEM
Good Afternoon Im trying to calculate Budget figure year to date, the budgets figures are in a different table to sales. The Budget table has 3 columns for date- year, ,month, week, whereas the date...
Ire_2022 , Using week and year create a date and use that to join to common date table
Date from week =
var _year = date([Year],1,1)
var _wyear = _year +-1*WEEKDAY(_year ,2)+1
return
_year + [Week]*7
Join this date with the date of the date table, also join the date table with the sales table. IF needed split the data into days
Ire_2022 , Using week and year create a date and use that to join to common date table
Date from week =
var _year = date([Year],1,1)
var _wyear = _year +-1*WEEKDAY(_year ,2)+1
return
_year + [Week]*7
Join this date with the date of the date table, also join the date table with the sales table. IF needed split the data into days