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 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))I still cant get pass through with that coding. May i know what i should put as table?
The highlighted value is the maximum value while the blue pointed pen is max value, and its not the same.
