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

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