Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello to all
I was creating the following calculated table:
Table 2 = ADDCOLUMNS ( SUMMARIZE ( 'Table A'; 'Table A'[issueid]; 'Table A'[Release] ; Table A'[LastRelease]); "Last Date"; CALCULATE ( MAX ( 'Table A'[created] ) ) )
Where Table A is the one in the attached image.
The problem is that for issuedid 10544 I'm getting not the last value based on created but the one before that.
In this case instead of getting 01/08/2017 15:54:01 I'm getting 01/08/2017 15:53:33 shich is not the last.
What am I doing wrong?
Thanks
Is the image your source table or output table? There is a possibility that you may need to use GROUPBY versus SUMMARIZE.
Any way that you can post the data your posted in an image as text? I really don't want to type all that in order to get this out.
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hello @Greg_Deckler
Like this?
id issueid created LastRelease
85304 10451 25/01/2017 15:51 FALSE
85341 10451 25/01/2017 16:04 FALSE
378810 10531 26/09/2017 13:19 FALSE
419087 10531 02/11/2017 17:07 FALSE
497931 10531 22/01/2018 18:16 FALSE
499825 10531 24/01/2018 18:21 FALSE
140026 10532 17/03/2017 17:05 FALSE
303169 10532 12/07/2017 17:06 FALSE
419137 10532 02/11/2017 17:56 FALSE
498667 10532 23/01/2018 16:24 FALSE
91089 10536 31/01/2017 16:00 FALSE
91092 10536 31/01/2017 16:00 FALSE
79506 10543 18/01/2017 19:22 FALSE
79505 10544 18/01/2017 19:21 FALSE
280843 10544 21/06/2017 12:57 FALSE
319832 10544 01/08/2017 15:53 TRUE
319833 10544 01/08/2017 15:54 FALSE
79517 10546 18/01/2017 19:44 FALSE
140020 10546 17/03/2017 17:03 FALSE
303159 10546 12/07/2017 17:01 FALSE
419116 10546 02/11/2017 17:24 FALSE
497932 10546 22/01/2018 18:17 FALSE
501003 10546 25/01/2018 17:49 FALSE
This should solve the issue.
Thanks @abhishekpati86, but not exactly, because I want the last created date for an issueid, and in your solution I have 4 entries to issueid 10544.
I think you are talking about the below similar issue. I hope it helps.
Hello @abhishekpati86
I was just testing you solution from the other post, but I have still not the solution.
First I can not add more columns (or at least doens't know how);
Second Lastdate function returns only the date, and I need the datetime. (the original value in the column)
How can I overcome this?
Create a measure as shown in the image below and it will solve your problem.
@abhishekpati86, Sorry for the late reply, easter break.
It is not working, or at least I'm not getting to the desire result, because it is giving me the MAX date from all the table and not by issueid.
Maybe I'm creating the measure in the wrong place?
@Greg_Deckler, did you have the chance to see the problem?
Struggling with max that is not max and LastDate that only gives me the "date" part.
Many thanks to both
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |