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.
I need to show the data Show Data in Matrix until last date in the last year . I need in this format, because is important at the analysis moment to compare name with only the last date
Hi,
I am not sure if I understood your question correctly, but I tried to create a sample pbix file like below.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your dataset.
Qty sum: =
SUM( Data[Qty] )
Only show when the last month is not blank: =
VAR _thelastmonth =
CALCULATE (
MAX ( Data[Month-Year] ),
INDEX (
-1,
ALL ( 'Month'[Month-Year], 'Month'[Month end date] ),
ORDERBY ( 'Month'[Month end date], ASC )
),
REMOVEFILTERS ( Customer[Customer] )
)
VAR _thelastmonthqty =
CALCULATE (
[Qty sum:],
FILTER ( ALL ( 'Month' ), 'Month'[Month-Year] = _thelastmonth )
)
VAR _condition =
NOT ISBLANK ( _thelastmonthqty )
RETURN
IF (
HASONEVALUE ( Customer[Customer] ),
[Qty sum:] * DIVIDE ( _condition, _condition )
)
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
22 | |
7 | |
6 | |
6 | |
6 |
User | Count |
---|---|
27 | |
12 | |
10 | |
9 | |
6 |