Forum Discussion
maximum value from table
Hi all, can anyone help me, i have been trying to extract the maximum value from this table, yet i was unable to do so. Is there any tricks or code that could help ? Thanks
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