MEASURE PROBLEM

[Ire_2022]

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

[Anonymous]

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

[amitchandak · Accepted solution]

@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