Forum Discussion
nitskulkarni
9 years agoRegular Visitor
Build trend analysis data
Hi All I have a report which is refreshedevery week an shows the snapshot of data after every refresh. I now want to keep the summary numbers in some static table/file and then show the trend based...
- 9 years ago
Hi,
I've just posted it :D
http://community.powerbi.com/t5/Desktop/Storing-and-using-information-from-a-dynamic-data-source-using/m-p/207294#M91339
v-huizhn-msft
9 years agoMicrosoft Employee
Hi nitskulkarni,
For your example, in week 1 the users have corrected the data for 2, we can not calculate how many users' data have been changed because the new data will cover the old data. You need to create a new table to record every week's number based on slicer, it means you need to create a dynamic table in Power BI desktop, it's impossible.
Best regards,
Angelia
Salvador
9 years agoResponsive Resident
Hello,
It is possible, I do it to analyze Dynamics CRM data, I'm currently translating the tutorial to english, will post a link here when i'm done :D