cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pierredelareux Regular Visitor
Regular Visitor

Re: Cumulative Total

It is what I'm looking for.

But I can't set it in mine. Power BI reject telling me there is to many values in [Date]. I have to use an aggregate function.

 

Which one do you advise me to take ?

 

Regards,

Pierre

Super User
Super User

Re: Cumulative Total

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

Hamburg - Germany
If I answer your question, please mark my post as solution, this will also help others.
I accept Kudos :-), If you find my post helpful.

Proud to be a Datanaut!
Highlighted
pierredelareux Regular Visitor
Regular Visitor

Re: Cumulative Total

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

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)