How to convert my current month expression to get March 2021 Amount ?

[admin11]

Hi All

I have below expression from @amitchandak , which can display April 2021 Amount correctly :-

PnL Apr 21 =

Var _1 = if(month(today()) >4, month(today()) -4, month(today()) +9)

VAR _MIN =

EOMONTH ( TODAY (), (-1* _1) -1 ) + 1

VAR _MAX =

EOMONTH ( TODAY (), (-1* _1) )

RETURN

TOTALYTD (

( GL[AMOUNT] ),

'Date'[Date],

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

)

I have below expression , may i know how to convert March 20201 Amount :-

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/03pp17n8me0mylz/PBT_V2021_400%20GL_TI.pbix?dl=0

Paul Yeo

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

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

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

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

[admin11]

@Ashish_Mathur 

Sorry for my initial post not so clear. I just check and found that your expression is same as Current Month expression. 

Now what i want is i want to get March 2021 Amount , this amount will be there when today date is june 2021. Meaning i need to hard code the expression for March 2021 . 

Some thing like below expression from @amitchandak for April 2021 Amount :-

PnL Apr 21 =

Var _1 = if(month(today()) >4, month(today()) -4, month(today()) +9)

VAR _MIN =

EOMONTH ( TODAY (), (-1* _1) -1 ) + 1

VAR _MAX =

EOMONTH ( TODAY (), (-1* _1) )

RETURN

TOTALYTD (

( GL[AMOUNT] ),

'Date'[Date],

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

)

Paul Yeo

[Ashish_Mathur]

How can my expression be the same as the current month expression.  Check again.

[admin11]

@Ashish_Mathur  

I am sorry , You are right , your expression is different from current month :-

But by changing the number , it will not be make the amount stay when next month. the point is i need to create the expression for month of march 2021.

ASK :-

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

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

Paul

[Ashish_Mathur · Accepted solution]

Hi,

I do not understand your question.  May be someone else will help you.

[admin11]

@Ashish_Mathur 

Thank you very much for info me. 
Also thank a lot for your past support.

Paul

[admin11]

@Ashish_Mathur 

it working fine. Thank you very much

Paul

[Ashish_Mathur]

You are welcome.