Forum Discussion

Anonymous's avatar
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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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?

  • abhishekpati86's avatar
    abhishekpati86
    Helper III
    8 years ago

    Create a measure as shown in the image below and it will solve your problem.

     

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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