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
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?
Hi Syndicate_Admin It gets filtered if you select any value and it gives max of selected date. If you need max irrespective of selected date then you can write measure as below:-
measure = calculate(Max(table[energydata_value]),All(table))
