Forum Discussion
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 Value is a complete date e.g. day, month, year
Could anyone help, please?
thanks
Ire_2022
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
2 Replies
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
Hi Ire_2022,
Did the above suggestion help with your scenario? if that is the case, you can consider Kudo or accept the helpful suggestions to help others who faced similar requirements.
If these also don't help, please share more detailed information to help us clarify your scenario to test.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
