Forum Discussion
Store SUM from table 1 in table 2
Super UserQ1: Edit queries and unpivot columns (in the transform tab). That can switch columns with rows.
Q2: build relationship between two tables, then you can use calculate(sum(amount), week="week1"). I am also a new users and hope that can help you.
Hi Ryan
Thanks for reply.
Q1: For table 1 I have database connection with base data, I then adding DAX calculation columns to do projection and these columns not appearing in Power Querie. It looks like that I have to use either DAX or Power Querie, but not both at the same time.
Q2: calculate(sum(amount), week="week1") - this would sum totals only for Week 1, but how to "tell table 2" that for Week 1 it has to take sum from Week 1 (Table 1), for Week 2 sum from Week 2 (Table 1), for Week 3 sum from Week 3 (Table 1) etc... and all this happens in the same column.