Forum Discussion
Not getting the max expected value
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
10 Replies
- Greg_DecklerCommunity Champion
Is the image your source table or output table? There is a possibility that you may need to use GROUPBY versus SUMMARIZE.
- AnonymousNot applicable
Greg_Deckler it is the source. Groupby using issuedid?
- Greg_DecklerCommunity Champion
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