Forum Discussion
Solved
Getting 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...
Hi,
This measure pattern should work
Total = sum(Data[Sales])
Last date = calculate(max(calendar[date]),lastnonblank(calendar[date],calculate([Total])))
Hope this helps.
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
You are welcome. Since this question is unrelated to the topic mentioned in the thread, please start a new thread in the forum.