Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello ,
I have a problem on the calculation of the minimum of a column.
I want to find the origine of the last puchased project by (client, year , month and program ).
My measure I want to display is :
for each origin how much client got the last purchased project through them ?
I need to get 1 or partenaire site and 0 for call center
same thing when filtring on a specific program I need 0 on
The dax I used for the Min is as below
Any suggestions will be much appreciated
Thank you in advance
Hi @NoaLowraee
I do not understand.
1. What is the meaning of the Last Created column?
2. Why are you using MIN( ) if you want the latest date??
3. What would be the expected result if you select Paris? And New York?
4. Why Store1 appears first in Norway and then in Singapore???
|
Please accept the solution when done and consider giving a thumbs up if posts are helpful. Contact me privately for support with any larger-scale BI needs, tutoring, etc. |
Hello,
Thank you for your reply.
I updated My Topic to be more concise possible.
Thank you in advance for your reply.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
85 | |
74 | |
69 | |
65 |
User | Count |
---|---|
214 | |
124 | |
117 | |
82 | |
76 |