How to remove P&L row which is not required ?

[admin11]

Hi All

I have below expression from @amitchandak  , is working fine , but i need to remove the extra row which is not necessary.

Current month - 1 PnL =

VAR _MIN =

EOMONTH ( TODAY (), -4 ) + 1

VAR _MAX =

EOMONTH ( TODAY (), -3 )

RETURN

TOTALYTD (

( GL[AMOUNT_1] ),

'Date'[Date],

FILTER ( 'Date', AND ( 'Date'[Date] >= _MIN, 'Date'[Date] <= _MAX ) )

)

My PBI file :-

https://www.dropbox.com/s/2u3bhe54yk67ckp/PBT_V2021_400%20GL_TI.pbix?dl=0

Paul Yeo

[MFelix · Accepted solution]

Hi @admin11 

Current month - 1 PnL =
VAR _MIN =
    EOMONTH ( TODAY (), -4 ) + 1
VAR _MAX =
    EOMONTH ( TODAY (), -3 )
RETURN
    IF (
        ISBLANK ( [PnL_LYTD] ),
        BLANK (),
        TOTALYTD (
            ( GL[AMOUNT_1] ),
            'Date'[Date],
            FILTER ( 'Date', AND ( 'Date'[Date] >= _MIN, 'Date'[Date] <= _MAX ) )
        )
    )

[aj1973]

Hi Paul,

Uncheck the Blank box in the filters