Forum Discussion
Use PowerBI to Adjust Values in Excel to Re-calculate Data
We have an Excel file containing lots of event data for different machines. On the second worksheet (within the same Excel file) we are able to type in two dates which then re-calculates reliability ...
Hi,
We have an Excel file which is constantly being manually updated with event times and descriptions. On the other worksheet in the same file, we are able to calculate Reliability of all the machines based on two dates which are input by the user. Is there a way to get PowerBI to change these dates, say using a time slicer, which then updates the calculated values in the spreadsheet (and then updates PowerBI charts etc.)?