Need help with dax formule (lastdate?)

[Sparkeltje]

Could you help me to show 1 result in visual CARD:

All I want to see is the latest period from the filters FK-DB and TEXT1  (For example: from the table below I would like to see  6.)

Table

FK_DB	Description	Period	Date
OH	Text 1	4	30-04-2020
OH	Text 1	6	30-06-2020
OH	Text 2	4	24-04-2020
OH	Text 2	7	30-06-2020

[amitchandak]

@Sparkeltje , Try like

lastnonblankvalue(Table[Date],max(Table([Period])))

refer

https://www.linkedin.com/pulse/five-recent-power-bi-functions-you-should-use-more-often-amit-chandak

[camargos88 · Accepted solution]

Hi @Sparkeltje ,

If you have more values for the columns FK-DB and Description, you may need to use a filter in this measure, like:

CALCULATE(MAX(TABLE[PERIOD]), FILTER(ALL(TABLE), TABLES[FK-DB] = "OH" && Description = "Text 1"))

[AntrikshSharma]

Measure =
CALCULATE ( MAX ( Spark[Period] ), ALLSELECTED ( Spark ) )