Forum Discussion
Helper IGetting Lates Date with a value from a Semantic Model
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:
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
Hi,
This measure pattern should work
Total = sum(Data[Sales])
Last date = calculate(max(calendar[date]),lastnonblank(calendar[date],calculate([Total])))
Hope this helps.
3 Replies
- Ashish_Mathur
Super User
Hi,
This measure pattern should work
Total = sum(Data[Sales])
Last date = calculate(max(calendar[date]),lastnonblank(calendar[date],calculate([Total])))
Hope this helps.
YesPIt 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 needPlease 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.