Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |