Forum Discussion

bv2023's avatar
bv2023
New Member
3 years ago
Solved

Return the latest value by date and condition

Hello,   I would like to have a PowerBI Card or Multi-row Card show the latest value from a table based on time and other conditions.   I have the following table from which I will be pulling inf...
Need Help
  • bv2023's avatar
    bv2023
    3 years ago
    LATEST=

    VAR last_value = MAX(Data[datstamp])
    VAR tag = "C2A"

    Return
    MAXX(FILTER(ALL(Data),Data[datstamp]=last_value &&
    Data[strname]=tag),
    Data[fltvalue])
bv2023's avatar
bv2023
New Member
3 years ago
LATEST=

VAR last_value = MAX(Data[datstamp])
VAR tag = "C2A"

Return
MAXX(FILTER(ALL(Data),Data[datstamp]=last_value &&
Data[strname]=tag),
Data[fltvalue])