Gruyere Column

[DavidB023]

Hi everybody !

I have these kind of table :

And I don't understand why when I enter this measure :  

I have the value of mai 2017 like that : 

 My goal is to have the last value but not at the last date because its empty..
Thanks

Best regards

David

[Anonymous]

Hi David,

you're getting the may figure as it is the highest non blank figure, try the expression below and see if it does what you need (may not be the most elegant!):

DRC F =
    VAR MaxDate =
        CALCULATE ( MAX ( 'PVCE'[Date] ); 'PVCE'[DRC] <> BLANK () )
    RETURN
        IF (
            DISTINCTCOUNT ( 'PVCE'[Date] ) = 1;
            SUM ( 'PVCE'[DRC] );
            CALCULATE ( SUM ( 'PVCE'[DRC] ); 'PVCE'[Date] = MaxDate )
        )

[Anonymous · Accepted solution]

You should actually be able to strip this down further:

DRC F =
    VAR MaxDate =
        CALCULATE ( MAX ( 'PVCE'[Date] ); 'PVCE'[DRC] <> BLANK () )
    RETURN
            CALCULATE ( SUM ( 'PVCE'[DRC] ); 'PVCE'[Date] = MaxDate )
        

[DavidB023]

@Anonymous Perfect ! Thanks