Power BI show last figure in data column in card visual

Question

I have the need to show the latest figure in a dataset within a card visual. This data is added to each month so i have a need to only show the latest month. I've currently got this measure but it doesnt seem to be working. Any help?

last = 

var last_value = MAX('Civils CRE ATW New'[# Staff])

RETURN
MAXX(
FILTER(ALL('Civils CRE ATW New'),'Civils CRE ATW New'[# Staff] = last_value),
'Civils CRE ATW New'[# Staff]
)

Can you add two columns of sample data? What type of data is #Staff? Where's your time column? — pgSystemTester
– pgSystemTester, Commented Mar 18 at 20:51

Ryan · Accepted Answer · 2025-03-19 00:47:31Z

0

you need to have a column that can display orders. e.g. date column

Measure =
VAR _date =
    MAX ( 'Table'[date] )
RETURN
    MAXX ( FILTER ( 'Table', 'Table'[date] = _date ), 'Table'[value] )

answered Mar 19 at 0:47

Ryan

2,6891 gold badge2 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

MJobbson · Accepted Answer · 2025-03-19 09:07:24Z

0

I found the below solution to work for my problem.

Latest = LASTNONBLANKVALUE('table'[column], SUM('table'[column]))

answered Mar 19 at 9:07

MJobbson

1831 silver badge10 bronze badges

Collectives™ on Stack Overflow

Power BI show last figure in data column in card visual

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related