Forum Discussion

pierredelareux's avatar
pierredelareux
Icon for Helper I rankHelper I
9 years ago

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...
Need Help
Show and Tell
Tutorial Requests
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
9 years ago

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

pierredelareux's avatar
pierredelareux
Icon for Helper I rankHelper I
9 years ago

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