Forum Discussion
Cumulative Total
Hi, I know this topic has been treated but I have a special request. Thanks to article I found the way to get the cumulative total as a mesure like below : Budget Corrigé Cumulé = VAR CurIn...
What, ...
You are saying that the Power BI file that uses the reduced dataset of your "made up" Excel file works as you expected, but as soon as you take one of the Formulas, lets say "BUDGET SUM" to your Power BI file
BUDGET SUM =
CALCULATE(SUM(data[BUDGET]),
FILTER(ALL('data'[DATE]),'data'[DATE] <= MAX('data'[DATE]))
)Power BI Desktop throws an error ??? this is odd.
I'm using the lastest Power BI Desktop version "2.47.4766.801 64-bit (June 2017)", there has been an update, to the 1st June release due to some errors.
Some other questions
- I assume that you are using ";" as a separator for formula arguments, did you change the "," (both) to ";"
- How many rows does your Dataset contain, is it the same as in your data.csv
- Are you sure that your values in the [Date] column are valid dates
Can you please provide a Screenshot of your adjusted formula and of the error message, maybe you encountered a bug
Find my answers below.
Some other questions
- I assume that you are using ";" as a separator for formula arguments, did you change the "," (both) to ";" YES
- How many rows does your Dataset contain, is it the same as in your data.csv - 4120 lines
- Are you sure that your values in the [Date] column are valid dates - I change null values to "01/01/2016"
Probelm is still occuring
Pierre