Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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
Solved! Go to 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.
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:
You are welcome. Since this question is unrelated to the topic mentioned in the thread, please start a new thread in the forum.
Hi,
This measure pattern should work
Total = sum(Data[Sales])
Last date = calculate(max(calendar[date]),lastnonblank(calendar[date],calculate([Total])))
Hope this helps.
User | Count |
---|---|
84 | |
78 | |
70 | |
47 | |
41 |
User | Count |
---|---|
108 | |
53 | |
50 | |
40 | |
40 |