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 = FORMAT(MAX(Sales[Month]), "mmm yyyy") then result is showing on "Dec 2023" that actually last data available is on "Aug 2023".

 

 

Any suggestion/advise to fix this issue?

 

Sample link - https://drive.google.com/drive/folders/1V2BPZtg7obFYI2dBQlT8rEIsYVy5wTGt?usp=sharing 

 

Thanks and Regards,

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

3 Replies

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    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
    Super User
    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