Forum Discussion

aakgun's avatar
aakgun
Frequent Visitor
10 years ago

Help using Earlier in New Measure

Hello,   I need to have measure that will display dynamic values according to specific rows.   I have created similar logic in custom data column using Earlier function. But while creaitng same c...
General Comment
Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
10 years ago

aakgun

 

A simple demo to show how apply EARLIER in a measure.

 

RunningTotal Measure = CALCULATE(
SUM( Table1[amount] ),
FILTER(  ALL(Table1) ,
SUMX( FILTER( Table1, EARLIER( Table1[date] ) <= Table1[date] ), Table1[amount] )
)
)

 

 

Due to low definition of the snapshots in your original post, I can't get what is the error message. If possible, upload your pbix with sample data, it can help to make your question more clear.

POB's avatar
POB
Frequent Visitor
7 years ago

The sample code provided works as advertised and was exactly what I needed, but I hate to use something I don't understand and this is in that category.

 

My understanding of the FILTER function is that the second parameter must be a Boolean expression.  When I look at the top level FILTER function in the sample code, it uses SUMX as it's filtering expression, which I think would evaluate to a numerical result rather than a Boolean one.  What am I missing?

 

I have looked at lot of other FILTER examples and I have yet to find something else like this.  Can you shed some light on how and why this works?