maximum value from table

[Anonymous]

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

[Samarth_18]

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

[Anonymous]

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

[Samarth_18]

Okay in this case you can use above code and you will get output like this:-

[Syndicate_Admin]

with a specific date, its not detecting the maximum value. Is there other way i could do this?

[Samarth_18]

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))

[Anonymous]

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.

[Anonymous · Accepted solution]

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

[Samarth_18]

@Anonymous , could you please elaborate what should be expected output?

[Syndicate_Admin]

The maximum number is pointed with blue arrow but with the code, i obtained value highlighted.

hmm