Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi Everyone, I'm struggling in this code, if anyone can help please - I want to fetch only last values from different months and show in a matrix. For example -
Jan - $4,724,484.1 |
Feb - $6,321,244.7 |
try like
1) add a column like:
MONTH = FORMAT([Date], "mmm")
2) plot a visual with the month column and a measure like:
LastRevenue=
VAR _monthtable =
FILTER(
ALL(TableName),
MONTH([Date]) = MONTH(MAX([Date]))
)
VAR _lastdate =
MAXX(
_monthtable,
[Date]
)
RETURN
MAXX(
FILTER(
_monthtable,
TableName[Date] = _lastdate
),
TableName[Online Revenue]
)
@gfreeman thanks for the response, I have tried that however it's throwing an error. Please help me understand this
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
10 | |
10 | |
9 | |
6 |