Append measure result from given query to another one after each update

[Anonymous]

Hello,

Actually trying to produce some reports on a website I'm handling, I'm looking for a way to do this :

1) Operate some measures on an imported table

2) Append automatically results on a new table with timestamp for each result each time I update the imported table.

Some topics on appending data to a new table exist, but I'm not sure if this case is already took on.

Best

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

First, you must know that calculated measure will be changed when you do a interaction in the report.
Notice:
1. Calculation column/table not support dynamic changed based on filter or slicer.
2. measure can be affected by filter/slicer, so you can use it to get dynamic summary result.
here is reference:
https://www.sqlbi.com/articles/calculated-columns-and-measures-in-dax/
Second, for your case, you could use your logic to create a new calculated table but not append the result to basic table.

Best Regards,

Lin