Forum Discussion

nitskulkarni's avatar
nitskulkarni
Regular Visitor
9 years ago
Solved

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...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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's avatar
Salvador
Icon for Responsive Resident rankResponsive Resident
9 years ago

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