Can we pull data from Source to Target module with different dimensions

priyanka1029
priyanka1029
in Modeling

Hi,

In my source module, i have Employee List and Line Items (Name, Date (Date Format), Salary)

In Target module, Have Employee List, Time and Line Items

What formula should i write to pull salary numbers from source to target module?

Thanks,

Priyanka

Answers

  • Kanishq17
    Kanishq17

    Hello , You can use period() to get the time period corresponding to date and then use SUM to aggregate over the time period

Categories