Forum Discussion

Anonymous

Not applicable

8 years ago

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...

Community Champion

8 years ago

Is the image your source table or output table? There is a possibility that you may need to use GROUPBY versus SUMMARIZE.

Anonymous
Not applicable
8 years ago
Greg_Deckler it is the source. Groupby using issuedid?
- Greg_Deckler
  Community Champion
  8 years ago
  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
  - Anonymous
    Not applicable
    8 years ago
    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

Related content