Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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 |
Solved! Go to 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"))
@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
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"))
Measure =
CALCULATE ( MAX ( Spark[Period] ), ALLSELECTED ( Spark ) )
User | Count |
---|---|
21 | |
19 | |
12 | |
9 | |
7 |
User | Count |
---|---|
30 | |
27 | |
14 | |
13 | |
10 |