Forum Discussion

NewUser1989's avatar
NewUser1989
New Member
2 years ago
Solved

How to Display Recent Value in Card Visual

Hi there!   I want to display using the card visual the recent value from my table (an excerpt from the original table), the recent % diff, which in this case is 0.29. And will remain so and will n...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • Sahir_Maharaj's avatar
    Sahir_Maharaj
    2 years ago

    Hello NewUser1989,

     

    Can you please try this:

     

    1. Find the most recent date with a 'Submitted' value

    LastSubmittedDate = 
LASTNONBLANK(
    'YourTableName'[Date],
    'YourTableName'[Submitted]
)

    2. Retrieve the '% diff' for the latest 'Submitted' date

    Recent % Diff = 
VAR LastDate = [LastSubmittedDate]
RETURN
IF(
    ISBLANK(LastDate),
    BLANK(),
    CALCULATE(
        MAX('YourTableName'[% diff]),
        FILTER(
            'YourTableName',
            'YourTableName'[Date] = LastDate
        )
    )
)

    Once you have the "Recent % Diff" measure, drag it into a card visual to display the most recent "% diff" value. Should you require my further assistance, please do not hesitate to reach out to me. 

Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
2 years ago

Hello NewUser1989,

 

Can you please try this:

 

1. Find the most recent date with a 'Submitted' value

LastSubmittedDate = 
LASTNONBLANK(
    'YourTableName'[Date],
    'YourTableName'[Submitted]
)

2. Retrieve the '% diff' for the latest 'Submitted' date

Recent % Diff = 
VAR LastDate = [LastSubmittedDate]
RETURN
IF(
    ISBLANK(LastDate),
    BLANK(),
    CALCULATE(
        MAX('YourTableName'[% diff]),
        FILTER(
            'YourTableName',
            'YourTableName'[Date] = LastDate
        )
    )
)

Once you have the "Recent % Diff" measure, drag it into a card visual to display the most recent "% diff" value. Should you require my further assistance, please do not hesitate to reach out to me.