Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Thank you for any help. Trying to get a calculated column 'Monthly_Change' that, for each row, subtracts the RT value on the last ActionDate in the previous month from the current RT value. Tried this, didn't work:
Solved! Go to Solution.
hi @lsealy ,
not sure if i fully get you, supposing you have a data table like:
date | RT |
9/1/2023 | 4 |
9/9/2023 | 4 |
9/17/2023 | 1 |
9/25/2023 | 2 |
10/3/2023 | 3 |
10/11/2023 | 2 |
10/19/2023 | 2 |
10/27/2023 | 6 |
11/4/2023 | 4 |
try to add a calculated column like:
column =
VAR _prt=
MAXX(
TOPN(
1,
FILTER(data, data[date]<=EOMONTH(EARLIER(data[date]), -1)),
data[date]
),
data[RT]
)
RETURN
IF(
NOT ISBLANK(_prt),
[RT] - _prt
)
it worked like:
hi @lsealy ,
not sure if i fully get you, supposing you have a data table like:
date | RT |
9/1/2023 | 4 |
9/9/2023 | 4 |
9/17/2023 | 1 |
9/25/2023 | 2 |
10/3/2023 | 3 |
10/11/2023 | 2 |
10/19/2023 | 2 |
10/27/2023 | 6 |
11/4/2023 | 4 |
try to add a calculated column like:
column =
VAR _prt=
MAXX(
TOPN(
1,
FILTER(data, data[date]<=EOMONTH(EARLIER(data[date]), -1)),
data[date]
),
data[RT]
)
RETURN
IF(
NOT ISBLANK(_prt),
[RT] - _prt
)
it worked like:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
22 | |
17 | |
16 | |
11 | |
7 |
User | Count |
---|---|
27 | |
26 | |
12 | |
12 | |
12 |