Getting Lates Date with a value from a Semantic Model

[YesP]

Hi,

I am working with a Semantic Model created for a different department.

I created a calendar table with the MAX and MIN date of the date field of the Semantic Model.

I am trying to get the Last Date with a value but my Dax formule is giving me as result the Last date of the month.

This is my Dax: 

Latest Date in Data = CALCULATE(MAX('Calendar'[Date]), REMOVEFILTERS())

Result: 

The Semantic Model has data from all the organization and I am filtering it in Power BI for the Department ID that I need. The last Transaction of the Department ID I am filtering has a date of 12/13/2024.

I want my Dax folmule to bring me 12/13/2024 instead of 12/31/2024

Please advice,

Thank you

[YesP]

It works great Ashish. Thank you so much!

I have a different question about an issue I am having working with the same Semantic Model lines above. I am trying to get Total Number projects. I am using the following Dax:

Number of Projects = CALCULATE(DISTINCTCOUNT(Project[Project ID]),ALLEXCEPT('Calendar',('Calendar'[Date])))

but it is bringing me the Total Projects of all Departments. The Semantic Model has data from all the organization and I am filtering it in Power BI for the Department ID that I need

Please I will appreciate your help

[Ashish_Mathur]

You are welcome.  Since this question is unrelated to the topic mentioned in the thread, please start a new thread in the forum.

[Ashish_Mathur · Accepted solution]

Hi,

This measure pattern should work

Total = sum(Data[Sales])

Last date = calculate(max(calendar[date]),lastnonblank(calendar[date],calculate([Total])))

Hope this helps.