Forum Discussion
Solved
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 ...
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"))
camargos88
Community Champion
Community ChampionHi 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"))