Forum Discussion
maximum value from table
Hi Anonymous ,
You can try to update the formula of measure [maxxx] as below and check whether you can get the correct value. Please find the details in the attachment.
maxxx = CALCULATE ( MAX ( 'energykwh energydata'[energydata_value] ), ALLSELECTED ( 'energykwh energydata' ) )Best Regards
Hi Anonymous ,
You can create a measure with below code:-
measure = Max(table[energydata_value])
If you could share sample data in text formate with expected output then we can help you with more specific answer. 🙂
Thanks,
Samarth
The maximum number is pointed with blue arrow but with the code, i obtained value highlighted.
hmm
Hi Samarth,
I am not sure how to send the sample data in text format as im new to this but i will try to put it below.
Month Day Time Energydata_Value October 31 12.00 am 8949461.19 October 31 12.30 am 8949206.22 October 31 1.00 am 6732062.06 October 31 1.30 am 6731925.04 October 31 2.00 am 3475019.96 Hope this is right.
Thank you
Okay in this case you can use above code and you will get output like this:-
with a specific date, its not detecting the maximum value. Is there other way i could do this?
