Forum Discussion
Need help with dax formule (lastdate?)
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 |
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"))
3 Replies
- AntrikshSharma
Community Champion
Measure = CALCULATE ( MAX ( Spark[Period] ), ALLSELECTED ( Spark ) ) 
camargos88Hi 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"))
- amitchandak
Super User
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
