topic Re: Need help with dax formule (lastdate?) in DAX Commands and Tips

Need help with dax formule (lastdate?)

Sparkeltje — Tue, 21 Jul 2020 14:31:11 GMT

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

AntrikshSharma — Tue, 21 Jul 2020 14:45:57 GMT

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

camargos88 — Tue, 21 Jul 2020 14:52:23 GMT

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"))

amitchandak — Tue, 21 Jul 2020 16:14:14 GMT

Sparkeltje , Try like

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

refer