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 not be affected by the slicer until there is another value inputted under "Submitted" that will give another value for %diff. I can't seem to make this happen with lastdate and max function. Is there a DAX that will make this be possible?

 

Thanks and best regards.

 

DateSubmitted% from total% running totalCurrent % totalPrevious % total% diff
Oct 0760.44%47.8070%47.8147.370.44

Oct 08

   47.8147.810.00
Oct 09   47.8147.810.00
Oct 10   47.8147.810.00
Oct 11   47.8147.810.00
Oct 12   47.8147.810.00
Oct 1390.66%48.4649%48.4647.810.66
Oct 1440.29%48.7573%48.7648.460.29
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. 

1 Reply

  • 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.