Forum Discussion

ADSL's avatar
ADSL
Post Prodigy
2 years ago
Solved

Show Only the Last Data Updated

Dear BI Community Team,   I have a sales target table that contain data from Jan'23 till Aug'23 as the screenshot below.     So I have applied this measure to get the last data updated = F...
Need Help
  • Uzi2019's avatar
    Uzi2019
    2 years ago

    Hi ADSL 
    I have checked yoy sample file your data. Your data is upto Dec 2023 in your date range.

    You have applied visual filter condition where sales>0
    That why blank months have filtered out.
    Please try the below measure:

    Last Date Updated = CALCULATE(MAX('Calendar'[Date]),FILTER('Sales Target','Sales Target'[Amt]>0))
     

    If I answered your question please give kudos and accept it as a solution!
    Thanks

  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi ADSL 

    You can apply to this card the same filter that is on the graph.
    This will fix the issue 

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

ADSL's avatar
ADSL
Post Prodigy
2 years ago

Hi Uzi2019 & Ritaf1983 ,

 

Thank you for helpful feedback and getting the same result.

 

Best Regards,