Minimum calculation of a measure

[Syndicate_Admin]

Good morning, I am trying to show the minimum per hour of a range of dates, for example for the 21st hour the minimum I want to get is -36.58 or in the case of the 22nd hour get -27.56. The only thing I have obtained is the minimum at the daily level not the set of dates. Attached photo with the table I have:

[v-henryk-mstf · Accepted solution]

Hi @Syndicate_Admin ,

Do you want to create the value corresponding to the following condition.

Column =
RANKX (
    FILTER ( ALL ( 'Table' ), 'Table'[Hour] = MAX ( 'Table'[Hour] ) ),
    'Table'[Value],
    ,
    ASC,
    DENSE
)

M =
CALCULATE (
    MAX ( 'Table'[Value] ),
    FILTER (
        ALL ( 'Table' ),
        'Table'[Hour] = MAX ( 'Table'[Hour] )
            && 'Table'[Column] = 1
    )
)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnt75]

You would need 1 measure per hour, you could try

Min H21 = MINX( ADDCOLUMNS( ALLSELECTED('Date'[Date]), "@val", [H21]), [@val])

[Syndicate_Admin]

Good, I have already obtained the minimum with the formula that you put me before. Now I would like to make that constant value to include it in other tables and not be modified.

Thanks a lot!