Forum Discussion
Solutionf for simple action - ongoing sum from SQL-Data
i recieve data for test executions from a sql view. The view holds a row for each execution with a column holding the date of the execution. In Excel it is very easy to visualise the ongoing sum of e...
Without understanding your data model or the measure in question it is impossible to provide helpful answers.
A good question (i.e. one that will get you useful responses quickly) should include the following:
- A thorough description of the problem
- Enough to understand the logic involved and the business problem you are solving
- Enough to understand where the result is falling short of expectations
- An enumeration of steps you have taken and attempts you've made to fix the problem (measure definitions, model alterations), and where these fall short
- The full text (not a screenshot, but text using the code block functionality in these forums, so we can copy paste without introducing our own errors copying by hand from a screenshot) of all involved measures and column definitions (if any).
- Your model structure.
- At least a description of the facts and dimensions involved,with relevant fields listed, and relationship keys called out.
- If your model is nontrivial, a screen capture of the model diagram will be quite helpful, as well as sample data if you are able to share any (again, don't take a screenshot - we don't want to transpose pages of data to be able to help you).
- Sharing on OneDrive (or similar) a sample .pbix with the minimum amount of data to recreate your problem is the most helpful to us in providing fast, accurate responses to you.