Cumulative values by Date

[werafa]

Hi all,

I am trying to implement the cumulative values measure in MS Power BI - (which is supposed to be the engine for Excel Power BI).

I have attempted to follow the tutorial on http://www.daxpatterns.com/cumulative-total/.
I've created and loaded a date table.

I've created a relationship between Datekey[date ] and PBI_KPIs[DateTo]

I've copied in the dax code



CumulativeGCI =
CALCULATE(
SUM(PBI_KPIs[GCI]),
FILTER(ALL(DateKey[Date]), DateKey[Date] <= MAX (DateKey[Date])
)
)


and the .... thing won't work.
can anyone spot my error?

thanks

[werafa]

got it.

was bad syntax
correct DAX is



CumulativeGCI MEASURE =
CALCULATE(
SUM(PBI_KPIs[GCI]),
FILTER(ALL('DateKey'[Date]), 'DateKey'[Date] <= MAX ('DateKey'[Date])
)
)

[Bob Phillips]

Are you saying that it needs the apostrophes around the table name? That seems odd, it doesn't have any spaces within the name.

[werafa]

Can't say I know how, why or what.....
I poked it and it moved

There is probably another explanation, and I shall eventually learn what it is

:)
Werafa