cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
Administrator

¿Cómo eliminar la fila P&L que no es necesaria?

Hola a todos

Tengo la siguiente expresión de @amitchandak , está funcionando bien, pero necesito eliminar la fila adicional que no es necesaria.

Mes actual - 1 PnL =
_MIN VAR =
EOMONTH ( HOY (), -4 ) + 1
_MAX VAR =
EOMONTH ( HOY (), -3 )
devolución
TOTALYTD (
( GL[AMOUNT_1] ),
'Fecha'[Fecha],
FILTRO ( 'Fecha', Y ( 'Fecha'[Fecha] >= _MIN, 'Fecha'[Fecha] <= _MAX ) )
)

admin11_0-1620478241032.png

Mi archivo PBI :-

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

Paul Yeo

1 ACCEPTED SOLUTION
Syndicate_Admin
Administrator
Administrator

No @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 ) )
        )
    )

MFelix_0-1620483750059.png

View solution in original post

2 REPLIES 2
Syndicate_Admin
Administrator
Administrator

No @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 ) )
        )
    )

MFelix_0-1620483750059.png

View solution in original post

Syndicate_Admin
Administrator
Administrator

Hola Paul,

Desmarque la casilla En blanco en los filtros

aj1973_0-1620483393119.png

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!