Forum Discussion
Finding the maximum temperature recorded for a day
- 6 years ago
Hi VipulToshniwal ,
You can try this measure to achieve maximum temperature of a day:
Max_temperature of current day =
VAR _curr =
SELECTEDVALUE ( 'Table'[timestamp_IST] )
RETURN
CALCULATE (
MAX ( 'Table'[Temperature] ),
FILTER (
ALL ( 'Table' ),
YEAR ( 'Table'[timestamp_IST] ) = YEAR ( _curr )
&& MONTH ( 'Table'[timestamp_IST] ) = MONTH ( _curr )
&& DAY ( 'Table'[timestamp_IST] ) = DAY ( _curr )
)
)
You will get the result like this:
Here is the demo, please try it:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi VipulToshniwal ,
You can try this measure to achieve maximum temperature of a day:
Max_temperature of current day =
VAR _curr =
SELECTEDVALUE ( 'Table'[timestamp_IST] )
RETURN
CALCULATE (
MAX ( 'Table'[Temperature] ),
FILTER (
ALL ( 'Table' ),
YEAR ( 'Table'[timestamp_IST] ) = YEAR ( _curr )
&& MONTH ( 'Table'[timestamp_IST] ) = MONTH ( _curr )
&& DAY ( 'Table'[timestamp_IST] ) = DAY ( _curr )
)
)
You will get the result like this:
Here is the demo, please try it:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.