Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I have below expression from @amitchandak , which can display April 2021 Amount correctly :-
I have below expression , may i know how to convert March 20201 Amount :-
Solved! Go to 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 ) )
)
Hi,
I do not understand your question. May be someone else will help you.
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 ) )
)
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 :-
Paul Yeo
How can my expression be the same as the current month expression. Check again.
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
Hi,
I do not understand your question. May be someone else will help you.
You are welcome.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |