Show Only the Last Data Updated

[ADSL]

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,

[Uzi2019 · Accepted solution]

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

[ADSL]

Hi @Uzi2019 & @Ritaf1983 ,

Thank you for helpful feedback and getting the same result.

Best Regards,

[Ritaf1983 · Accepted solution]

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

[Uzi2019 · Accepted solution]

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