Forum Discussion
Table not reflecting changes in new data from another table
Hi. I currently have an issue whereby one table linked through an active relationship (Many to One, single filtered), isnt reflecting any new data input from the source table.
I have the source table with Resource# until 120:
Sub Table
...and this is the linked table:
Linked table
So as you can see, only Resource# until 114 has been copied from the Sub table, which is peculiar.
Any help is appreciated!
Hi Anonymous ,
Enter into Query Editor, click on all Day# column such as Day#15 -Day#17 at the same time, then choose "Unpivot Columns", rename this result column "Attribute" with "Day#" . Don't forget to click the "Close & Apply" button.
Then you can create measure like DAX below to get sum value for per Resource# and per Day# .
Measure1= CALCULATE(SUM(Table1[Value]),FILTER(ALLSELECTED(Table1),Table1[Resource#] =MAX(Table1[Resource#])&&Table1[Day#] =MAX(Table1[Day#])))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
- parry2k
Super User
Anonymous what is your actual question? What you are looking for?
- parry2k
Anonymous what is day #12, 13, 14 in linked table? Your question is not very clear, can you explain waht you are looking for final result? How does your raw data looks like?
v-xicaiCommunity Support
Hi Anonymous ,
Enter into Query Editor, click on all Day# column such as Day#15 -Day#17 at the same time, then choose "Unpivot Columns", rename this result column "Attribute" with "Day#" . Don't forget to click the "Close & Apply" button.
Then you can create measure like DAX below to get sum value for per Resource# and per Day# .
Measure1= CALCULATE(SUM(Table1[Value]),FILTER(ALLSELECTED(Table1),Table1[Resource#] =MAX(Table1[Resource#])&&Table1[Day#] =MAX(Table1[Day#])))
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
